COUNT - do you know the difference?

⭐ Microsoft Excel Tip:

Do you know the difference between COUNT, COUNTA, COUNTBLANK and COUNTIF?

First, what they all have in common. They are used to perform a counting calculation in your worksheets. What differs is WHEN they are used.

COUNT is used when you wish to count ALL of the cells you have selected that contain numbers. It ignores text. =COUNT(A1:A50)

COUNTA is used when you wish to count non-blank cells, any cell that has something in it, numbers, text, dates and error values. Maybe you are doing a headcount for an event and looking for ☑️ . =COUNTA(A1:A50)

COUNTBLANK is used when you wish to count ONLY blanks. Useful when you've missed an entry when inputting. =COUNTBLANK (A1:A50)

COUNTIF is used when you wish to count the number of cells that meet a criteria (ie. all cells that have the word apple in them). =COUNTIF(A1:A50, "apple")