What formula do I need for this task?
Is there a formula that will give me the totals (in white below) of the number of entries in each column, not their sum?
Thanks for your help.
Question marked as
Top-ranking reply
You want to count the numbers in each column. The function of choice would be COUNT.
If Row 1 (containing the formula) is a Header row, the formula is pretty simple:
If row 1 is NOT a header row, the formula will show an error triangle, as the 'full column' reference ( B ) includes all cells in a column excelt those in Header row cells or Footer row cells.
Column E is included to demonstrate the COUNT counts only cells containing numbers (or quasi numerical values, such as Date & Time values).
To count entries that are text (and entries of any data format), replace COUNT with COUNTA.
Regards,
Barry
PS: Neglected to format the counts to display in white and in larger characters. this is done in the Text section of the Format Inspector.
B.