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