I am trying to add up the number of rows on sheet one that meet two different criteria, and produce the result in sheet 2.
1) Column A contains "36" - this ranges from 1 to 52
2) Colum M contains "1" - this is always 1 or 0
My code:
=COUNT(AND(COUNTIF('2008 Schedule'!$A5:$A10000,"36"),COUNTIF('2008 Schedule'!$M5:$M10000,1)))
It just seems to return "1" all the time wheteher anything is added or not.
Any ideas please?
Thanks
1) Column A contains "36" - this ranges from 1 to 52
2) Colum M contains "1" - this is always 1 or 0
My code:
=COUNT(AND(COUNTIF('2008 Schedule'!$A5:$A10000,"36"),COUNTIF('2008 Schedule'!$M5:$M10000,1)))
It just seems to return "1" all the time wheteher anything is added or not.
Any ideas please?
Thanks