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
|