| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF across Worksheets
How can I turn a formula like:
=COUNTIF('Person 1'!$C8,"Off")+COUNTIF('Person 2'!$C8,"Off")+COUNTIF('Person 3'!$C8,"Off")+COUNTIF('Person 4'!$C8,"Off")+COUNTIF('Person 5'!$C8,"Off") Into (something like): =COUNTIF('Person 1':'Person 5'!$C8,"Off") ... this gives #NAME? =COUNTIF('Person 1:Person 5'!$C8,"Off") ... this gives #VALUE! It doesn't have to be the COUNTIF function so long as it achieves the same ends. I need to be able to add more people without a vast amount of repetition. It would look neater and simpler too! Thanks in advance Trevor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
