Please help with Sumproduct, adding additional criteria
try
=SUMPRODUCT((Data!E$1:E$2514=Lists!A13)*(Data!E$1 :E$2514<Lists!B13)*(Data!K$1:K$2514="Other")*(Data !M$1:M$2514<{"FA", "Nonrecordable"}))
change < to = for the second part of your question.
"Gina" wrote:
=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.
|