Hi Guys,


So I am trying to get a Master Sheet calculate results if a certain condition is met in the other 30 sheets..

eg:
Day 1 Column C4 and D4 are both equal or greater than 1
Day 2 Column C4 and D4 only C4 is equal to 1 and D4 = 0

I want Day 31 to show only "1" as a final result using a formula that out of all the day sheets only 1 day the criteria of both columns being 1 was met.

I have tried the "IF" function but its not working for all the sheets at once and I have to add like:
=IF('Day1'!C4>0,IF('4'!D4>0,"1","0"))+IF('Day2'!C4>0,IF('5'!D4>0,"1","0"))

Is there a way to do Day1:Day2 and other days together? I am sure there is...

Thanks.