Share this article:

What it does: The COUNT() function counts the cells that contain numbers.

Plain English: There are many types of COUNT functions, but this is the most basic. This will count the cells with numbers in them (not text, boolean values, blank cells, etc..)

Arguments: COUNT(Value,[Value2],[Value3],etc..)

  • Value – The first cell you want to check
  • Value2 – The second cell you want to check
  • Etc..

NOTE: You can also select a group of cells, ie “COUNT(A1:B20)”

Please remember that we may receive commissions when you click our links and make purchases