"What if" Scenarios used twice. With an adding sum at the end.

[simbalyon303]

I am having terrible trouble trying to figure out a code for what I am trying to do.
I have used combinations of things on the internet but still can not find a simple way to get the answer I want.

Please please help me as this would resolve a major problem at the end of a 7 day working spread sheet.

Statement:

If cell XX1 was "yes" and cell YY1 is "3" then add one,

To repeat this within a range of cells of two columns and 400 rows. If column XX1 was "yes" and column YY1 was "3" then it would add one to zero. This would repeat for each row.

So if out of 400 6 cells had "yes" and "3" then the total would be 6.

Sounds difficult but hopefully get my drift.

[modytrane]

take a look at the attached book
see the formula in "G2".
modytrane

[simbalyon303]

Modytrane thank you that works well to start with, but then how do I get it to count how many are both true to them rules, so the number in g2 would be 6.

Or if there was only 4 true ones then it would be 4

=SUMPRODUCT(--(D:D="yes"),--(E:E=3))

[simbalyon303]

Dont worry sorry it is working!

Thank you very much

[arthurbr]

Simbalyon,
if the formula in post #3 works, then you are not using XL2003 as stated in youy profile, but 2007 or 2010
In the future best add the correct version