Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If - additional criteria | Excel Discussion (Misc queries) | |||
Subtotal with additional criteria | Excel Worksheet Functions | |||
Adding additional string vs. look up table | Excel Worksheet Functions | |||
SUMPRODUCT - Additional criteria | Excel Worksheet Functions | |||
Additional Sumproduct Criterias | Excel Worksheet Functions |