ExcelExplained

How to use COUNTIF function in Excel

In this article, I will focus on how to use COUNTIF function in Excel. The purpose of COUNTIF is to count cells that meet a single criteria. If you need more criteria in your formula, then COUNTIFS function is...

How to use VLOOKUP function in Excel

VLOOKUP was created to lookup and retrieve data from a specific column in a table. It support approximate and exact matching and wildcards (* ?)

How to use EOMONTH function in Excel

Excel's EOMONTH function returns the last day of a month, N months in the future or the past.

Category - Functions

How to use COUNTIF function in Excel

In this article, I will focus on how to use COUNTIF function in Excel. The purpose of COUNTIF is to count cells that meet a single criteria. If you need more criteria in your formula, then COUNTIFS function is a much...