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. |
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 |