Thread: I need to add one more criteria to this function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Infinitogool Infinitogool is offline
external usenet poster
  
Posts: 52
Default 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
Reply With QuoteReply With Quote