Nesting Sumproduct and Sumifs not working

[Siyanna]

Hi

I am trying to change this formula to use Sumifs to make it faster (trying to use better formulas to speed up my spreadsheet) but i cant seem to get it to work

I am trying to do a multiple or with sumproduct

my current formula

=SUMPRODUCT(--(A2:A7=F7),--ISNUMBER(MATCH(B2:B7,Condition_List,0))),(D2:D7))

trying to change to

=SUMPRODUCT(--(A2:A7=F7),Sumifs(B2:B7,Condition_List),(D2:D7))

what am i doing wrong

 

[Glove_Man]

SUMIFS() is returning a single value.

--ISNUMBER() is returning an array of 6 values.....

The two formulas are doing completely different things. SUMIFS() is already adding up the cells, before applying the second criteria. A = F criteria

 

[Siyanna]

Im sure i read i can encorporate Sumifs to make it quicker

i may be wrong though

 

[steve the fish]

You can do that with a sumproduct sumifs:

=SUMPRODUCT(SUMIFS(D2:D7,A2:A7,F7,B2:B7,Condition_List))