Difference between all 5 count functions (COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK) in Excel.

Excel Data for Count, CountIF, CountIFS, CountA and CoubtBlank Function

What is the difference between COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK in Ms-Excel? Suppose we have a table like this.   Different type of count functions The following table illustrated the differences between each function: Usage Count Count number of cells that have numbers or values CountA count any cell value containing numbers, text, logical values, … Read more