Counting stuff in Excel

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...

Count everything in an area

(How many entries have been completed?)

Only count specific items in an area

(How many of the items in this list are red?)

Count using two criteria

(How many hats in this list are red?)