Using Excel to count stuff

The COUNT function is used in Excel to find out how many items appear in a specific area of the worksheet.

Unfortunately for the unwary, COUNT only works for numbers. To get the most out of this family of functions, you need to know about COUNTA and COUNTIF as well

Try these short tutorials - the easiest one is at the top...

Counting everything in an area
(How many entries have been completed?)

Only counting specific items in an area
(How many of the items in this list are red?)

Counting using two criteria
(How many hats in this list are red?)

 

Tell somebody else...

Comments / Questions / Article suggestions...