Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two variables to get result | Excel Worksheet Functions | |||
TWO VARIABLES - ONE RESULT | Excel Discussion (Misc queries) | |||
showing lookup result with multiple variables | Excel Discussion (Misc queries) | |||
Making solver solve for different set variables and listing result | Excel Discussion (Misc queries) | |||
2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions |