Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping status on posed questions in Excel | Excel Discussion (Misc queries) | |||
I'm having trouble finding my posted questions? | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
2 questions: Using solver in Macro AND converting to Word document to print A3 | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |