Adding words up in a range

[Guest]

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.

 

[JulieD]

Hi

use the COUNTIF function

assuming "Hoovering" is in A4 and you want to count the number of people the
formula would be
=COUNTIF(B4:F4,"<>"&"")

Cheers
JulieD

 

[Jason Morin]

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

 

[Peo Sjoblom]

What is hoovering?

Where they make vacuum cleaners? <bg>