View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gina[_2_] Gina[_2_] is offline
external usenet poster
 
Posts: 49
Default Please help with Sumproduct, adding additional criteria

=SUMPRODUCT((Data!E$1:E$2514=Lists!A13)*(Data!E$1 :E$2514<Lists!B13)*(Data!K$1:K$2514="Other"))

I'd like to have this same number returned, but I'd like it to filter out
when

=Data!M1:M2500 does NOT equal "FA" or "Nonrecordable".

Can anyone help me with this?

Conversely, I'd like the same calculation in another cell

=SUMPRODUCT((Data!E$1:E$2514=Lists!A13)*(Data!E$1 :E$2514<Lists!B13)*(Data!K$1:K$2514="Other"))

that adds exclusively counts when the values of
=Data!M1:M2500 values are "FA" or Recordable"

Thank you.