Many thanks.
I'm favouring the SUMPRODUCT option ... but at least now I have some options
to consider which is a huge plus
Regards
Trevor
"JE McGimpsey" wrote in message
...
You can change the SUMIF()'s in the solution provided he
http://www.mcgimpsey.com/excel/threedsumif.html
to COUNTIF()s, and use SUM() to sum across sheets. If you use wrapper
sheets (e.g., all your new sheets go between the first and last), you
can use
=SUM(first:last!Z1)
to include all intermediate sheets.
In article ,
"Trevor Shuttleworth" wrote:
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