3 LookUp Variables One Result
 

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 P5:P120 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'!P5:P120,"=5")

Thank you,
Frusterated Iona

3 LookUp Variables One Result
 

=SUMPRODUCT(--(YEAR(O5:O120)=2008),--(MONTH(O5:O120)=7),--(P5:P120=5))


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

--


Regards,


Peo Sjoblom

"Iona" wrote in message
...
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 P5:P120 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'!P5:P120,"=5")

Thank you,
Frusterated Iona

3 LookUp Variables One Result
 

Thank you sooo much and Happy Monday!

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(YEAR(O5:O120)=2008),--(MONTH(O5:O120)=7),--(P5:P120=5))


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

--


Regards,


Peo Sjoblom

"Iona" wrote in message
...
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 P5:P120 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'!P5:P120,"=5")

Thank you,
Frusterated Iona