Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding words up in a range
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. |
#2
|
|||
|
|||
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 "Chris01623" wrote in 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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
What is hoovering? Where they make vacuum cleaners? <bg -- Regards, Peo Sjoblom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ClearContents method on a passed range | New Users to Excel | |||
Adding Range Names | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range name | Excel Worksheet Functions |