Ranges and functions · COUNT and COUNTAWorks in: all current Excel versions, Google Sheets

COUNT counts numbers

COUNT tells you how many cells in a range hold a number: =COUNT(F2:F13) counts the quantities, one per order. It ignores text and empty cells, so it's the right tool for “how many entries are there?” in a column of numbers.

Syntax
COUNT(range)
range
the cells to count. Only numbers (and dates) count.
Common mistakes
  • Using COUNT on names: text isn't a number, so the answer is 0.

Tap Try it to count the quantities.

ABCDEFGHIJK
1OrderDateCustomerProductCategoryQtyPriceStatusQty entries
210012 Mar 2026Mara OkaforMonsteraPlants1$34.00Shipped
310022 Mar 2026Jonas LindTerracotta potPots3$12.50Shipped
410033 Mar 2026Priya RamanSnake plantPlants2$22.00Shipped
510044 Mar 2026Tomás RuizWatering canTools1$18.00Pending
610055 Mar 2026Elif DemirFernPlants4$9.50Shipped
710065 Mar 2026Mara OkaforPotting mixSoil2$7.25Returned
810076 Mar 2026Kenji MoriPruning shearsTools1$24.00Shipped
910087 Mar 2026Ines VargaCeramic potPots2$19.00Pending
1010098 Mar 2026Jonas LindMonsteraPlants1$34.00Shipped
1110109 Mar 2026Sofia RossiFernPlants6$9.50Shipped
12101110 Mar 2026Priya RamanPotting mixSoil5$7.25Shipped
13101211 Mar 2026Leo BrandtSnake plantPlants1$22.00Pending

Tap Try it to type =COUNT(F2:F13) into K1.

Go deeper: SUM, AVERAGE, COUNT, MIN and MAX