3 LookUp Variables One Result

[Iona]

Hello Excel Geniuses,

It is ending day and I am ready to go home... and want to wish everyone a
great weekend!

I am trying to find the most effective formula for counting data that meets
3 conditions from one tab onto another tab. I am in Excel 2003.

Sheet 1 will be the results
Sheet2 is where the date is housed

Column O5:O120 Condition 1: >=01/01/09 (Customer Satisfaction Survey Date)
Column O5:O120 Condition 2: <=01/31/09 (Customer Satisfaction Survey Date)
Column P5120 Condition 3:>=5 (Customer Satisfaction Survey Score)

Here is my formula (it worked =)) I created in 2007 that is not compatible
with 2003.
=COUNTIFS('Site_Customer Log'!O5:O120,">=07/01/08",'Site_Customer
Log'!O5:O120,"<=07/31/08",'Site_Customer Log'!P5120,">=5")

Thank you,
Frusterated Iona

 

[Peo Sjoblom]

=SUMPRODUCT(--(YEAR(O5:O120)=2008),--(MONTH(O5:O120)=7),--(P5120>=5))


add your sheet names accordingly, will count P5:120 greater than or equal
to 5 during July 2008

--


Regards,


Peo Sjoblom

 

[Iona]

Thank you sooo much and Happy Monday!

=SUMPRODUCT(--(YEAR(O5:O120)=2008),--(MONTH(O5:O120)=7),--(P5120>=5))


add your sheet names accordingly, will count P5:120 greater than or equal
to 5 during July 2008

--


Regards,


Peo Sjoblom