how do i get a total for a list of names entered in

ie alan billy chris dave ......

also is it possible for the date to be automatically enterd in each sheet

tia

jkf

You have a list of names in a row?
=COUNTA(A1:Z1) for row 1 or =COUNTA(1:1)
In a column ?
=COUNTA(C1:C100) for column C or =COUNTA(C:C)
Whereas COUNT counts numbers, COUNTA counts everything.

=TODAY() add the current date which updates when the file is opened tomorrow
Using CTRL+; enter the current date in static form - will be yesterday's
date tomorrow

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jkf" wrote in message
...
how do i get a total for a list of names entered in

ie alan billy chris dave ......

also is it possible for the date to be automatically enterd in each sheet

tia

jkf

thank you for quick reply

answer to first was spot on thank you
second question i want the date to be the sheet was created and not to
change
i have sheet for each day of a month and i know each sheet as been allocated
a date but i also need to print a copy of each day and sometimes forget to
insert date lol

hope this makes sense

jkf


"Bernard Liengme" wrote in message
...
You have a list of names in a row?
=COUNTA(A1:Z1) for row 1 or =COUNTA(1:1)
In a column ?
=COUNTA(C1:C100) for column C or =COUNTA(C:C)
Whereas COUNT counts numbers, COUNTA counts everything.

=TODAY() add the current date which updates when the file is opened
tomorrow
Using CTRL+; enter the current date in static form - will be yesterday's
date tomorrow

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jkf" wrote in message
...
how do i get a total for a list of names entered in

ie alan billy chris dave ......

also is it possible for the date to be automatically enterd in each sheet

tia

jkf