Do you need to total the number of nonblank cells in a row or column that contains only text entries? You can do this easily with Excel's CountA function.
Suppose you need to keep track of attendance at a five-day seminar. In column A, you list all registered attendees; in cells B1 through F1, you list the dates of the seminar. Next to each name in column A, you place the letter "A" in column b to indicate who attended the conference the first day.
For example, say there were 50 attendees, and you entered the attendance data in cells B2:B51. To obtain a total of all attendees for the first day, in cell B52 enter the following formula: =COUNTA(B2:B51).
To obtain the total attendance for each remaining day of the seminar, simply copy the formula across the range C52:F52.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.