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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to add one more criteria to this function
Gina,
All the conditions come before the comma, and are joined by the asterisk (which means AND), so you can do this: =MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U & E")*(Data! J2:J2500<"FA"),Data!C2:C2500)) Don't forget to use CSE to commit it. Hope this helps. Pete On Aug 1, 5:29*pm, Gina wrote: =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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to add one more criteria to this function
Hi Gina
Try =MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U & E")*(Data!J2:J2500<"FA",Data!C2:C2500)) Regards, Pedro J. =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to add one more criteria to this function
Thank you so much. This works great. You guys are a godsend for someone who
hasn't done much work in excel for the last 3 years, and suddenly has more projects in Excel than thought possible. Gina "Pete_UK" wrote: Gina, All the conditions come before the comma, and are joined by the asterisk (which means AND), so you can do this: =MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U & E")*(Data! J2:J2500<"FA"),Data!C2:C2500)) Don't forget to use CSE to commit it. Hope this helps. Pete On Aug 1, 5:29 pm, Gina wrote: =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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to add one more criteria to this function
You're welcome, Gina - glad to be of help (as we all are).
Pete On Aug 1, 6:53*pm, Gina wrote: Thank you so much. *This works great. *You guys are a godsend for someone who hasn't done much work in excel for the last 3 years, and suddenly has more projects in Excel than thought possible. Gina |
Reply |
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 |