| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks so much!
"Dodo" wrote: "?B?c2hld2FoeWE=?=" wrote in : I am trying to do a sign in sheet and would like horizontally at the top name, address etc, and name is in A1, address is in B1 etc. for example. Is there a way to make it so the numbering will reflect how many people sign in without adding a column with numbering? Thanks in advance. Teresa You can add a formula in a cell to count non-empty cells: =counta(range) where range are the cells where the names are entered or the attendance is marked, e.g. =counta(a2:a328) -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
