2 questions
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 |
2 questions
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 |
2 questions
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 |
All times are GMT +1. The time now is 03:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com