Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to add one more criteria to this function
=MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U & E"),Data!C2:C2500))
I would like to add a filter (Data!A2:A2500=2008)*(Data!G2:G2500="U & E") and Data!J2:J2500 does not equal "FA" to the above function. I'm not sure how to do this. Gina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum If function with 2 criteria | Excel Worksheet Functions | |||
criteria function using max | Excel Worksheet Functions | |||
If Function. How to Add more criteria | Excel Worksheet Functions | |||
Function for more than 1 criteria | Excel Worksheet Functions | |||
How do I use the SUM IF function with two different criteria. S. | Excel Worksheet Functions |