What is hoovering? Try using COUNTA. For example:
=COUNTA(B2:F2)
HTH
Jason
Atlanta, GA
-----Original Message-----
I have a word in a different cells on a row in my
spreadsheet e.g.
Mon Tues Wed Thur
Fri
Hoovering Nicola James
Washing up
Steve Lisa
etc
I would like to know a formula that could add up the
amount of names that
have been allocated for a certain task, and that would
automatically change
if a name was added or taken away, so i can have
a "total" column in a
different cell elsewhere in the spreadsheet telling me
how many people there
are.
.
|