| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count entry only once across multiple worksheets?
Hello,
How can I count each worksheet a criteria appears on in a range of cells? Not the number of times it appears total, but the number of sheets it appears on. For example: The range is H9:H32, the entry I'm needing to count is "other" and there are 250 sheets. I don't want the total number of times the word "other" appears, but the total number of sheets it appears on in that range. Make sense? Thank you very much in advance. Any assistance would be greatly appreciated. tgcali |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum multiple values for a single entry | Excel Discussion (Misc queries) | |||
| Fprced data entry on multiple worksheets | Excel Worksheet Functions | |||
| Populating Multiple Worksheets with one entry | Excel Worksheet Functions | |||
| Merging multiple worksheets into one, with ongoing data entry | Excel Discussion (Misc queries) | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
