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

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

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

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

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