LoveByPDF logo

LoveByPDF
EN

Basics · COUNT, COUNTA, COUNTBLANK

COUNT vs COUNTA vs COUNTBLANK - counting cells in Excel

COUNT counts cells holding numbers, COUNTA counts every filled cell (text too), COUNTBLANK counts empty ones.

=COUNT(range)   =COUNTA(range)   =COUNTBLANK(range)
Write it for my sheet

Examples

Type this in the Formula StudioFormula
“count from A2 to A10”=COUNT(A2:A10)
“count all from C4 to AG4”=COUNTA(C4:AG4)
“count blanks in D2:D20”=COUNTBLANK(D2:D20)
“A2 se A10 tak ginti karo”=COUNT(A2:A10)

Tips

  • COUNT on text cells gives 0 - the studio switches to COUNTA automatically when the cells hold text such as P / A / L.

People also search for

  • count formula in excel
  • counta formula in excel
  • difference between count and counta
  • countblank formula in excel
  • how to count cells in excel
  • count non blank cells in excel
  • count text cells in excel
  • excel count formula with example
  • count formula in excel in hindi

FAQ

What is the difference between COUNT and COUNTA?

COUNT counts only cells containing numbers (dates count as numbers). COUNTA counts every non-empty cell, including text, errors and formulas returning "".

Why does COUNT return 0 on my sheet?

The cells contain text such as P / A / L or numbers stored as text. Use COUNTA for any filled cell, or COUNTIF to count a specific value.

Can LoveByPDF write this formula for me?

Yes. Open your Excel file in the Excel Agent's Formula Studio, click a cell and type what you need - e.g. "count from A2 to A10" - you get the formula, a preview on your sheet and an explanation, then insert it.

Related formulas