Excel 2007 : OR Statement in Count IFs?

[TinkerBleu]

Hello Everyone-

I am working on a countif and think I need to use the OR Function (is it possible?) - I have 3 rows that could contain my data - also using a date criteria, and a column with info populated from a drop down menu. - Here is what I have:

Formula Entered in A1;Sheet 2

In Sheet 1
If A2 = Yes
OR if C2 = Yes
Or if E2=Yes
And if F2 = 12/1/2011
And if e2 = Win (or Lose) E2 is a drop down.
= my total

Any ideas? Your help is much appreciated!

Daun

[dip11]

Something like this?
=IF((COUNT(A2,C2,E2)>0),IF(F2=12/1/2011,IF(E2<>0,"Yes",""),""),"")

You may need to recode your Yes/No to 1/0 for this to work.
Not sure what you mean by "my total". I replaced it with "Yes" in the formula. You can change that part to do anything you want though.

[dilipandey]

Hi Daun,

See the attached file where I have tried understanding your issue.
Go through the same and explain a little more.

Regards,
DILIPandey

< click on below 'star' if this helps >