Add Data in Different Sheets and Result in Master Sheet based on Cell Values

[dksodhi]

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.

[Legend Rubber]

what about the IF(AND( function?
Have you tried that?

[dksodhi]

Nope...dont know how that works!

[Legend Rubber]

OK, it may work, can you give me a bit more info as to what you want to do? a sample workbook would be great help...

P.S. i was in Adelaide in Jan 2011, very beautiful place.

[dksodhi]

Hi....Love Adelaide...
Ironically, I may be visiting Toronto in Dec.

Sample sheet attached.

[Teethless mama]

=sumproduct(countifs(indirect("'"&row(indirect("4:6"))&"'!c4"),">0",indirect("'"&row(indirect("4:6"))&"'!d4"),">0"))

[dksodhi]

Thank u so much...Works Great!

[Teethless mama]

You're Welcome!