I need to add one more criteria to this function

[Gina]

=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

 

[Pete_UK]

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

 

[Infinitogool]

Hi Gina
Try
=MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U &
E")*(Data!J2:J2500<>"FA",Data!C2:C2500))

Regards,
Pedro J.

 

[Gina]

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]

You're welcome, Gina - glad to be of help (as we all are).

Pete