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 |
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 |