View Single Post
  #2   Report Post  
Dodo
 
Posts: n/a
Default

"?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)