The COUNT and COUNTA functions in Excel 2007 have basic definitions that we can breakdown and help you use them correctly. COUNT function is used to to count numbers of cells in a range of cells that contains numbers. Simply type in a blank cell =cou and you'll see a menu pull up, and then you can double-click COUNT and then click and drag to select a range of cells you want to include in the count and hit Enter. The COUNTA function will count the number of cells in a range of cells that are NOT empty. So you can count up a range of cells of employee who have say benefits, or a column of cells that have data in them like DB for Dental Benefits and so on....

Purchase the training video and you can see this in action for yourself!