Dec 16 2018 09:16 AM
Hi
Im wondering if someone can help, im creating a table of a list of names both first and last names and I need to keep a count of how many people there are. Is there a way of renaming the column so that I can use the numbers down the side. EG. Column A rather than being A I could call it first name something like below
A B C D
1
2
3
4
5
could become
First name Last name
1
2
3
4
Dec 16 2018 10:05 AM
Hi,
what is the connection between counting entries and the column header?
Counting is simply:
=COUNTA(A:A)
or when formatted as a table:
=COUNTA(Table1[First name])