naming a collum

[djwebb]

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

[#2]

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])