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...
(How many entries have been completed?)
(How many of the items in this list are red?)
(How many hats in this list are red?)