Forum Discussion

Copper Contributor

Feb 13, 2023

Solved

Sumifs

can I perform a sumifs where the criteria can be more than 1 possibility in the same range? I tried this and it didn't work: =SUMIFS(Benita!M2:M59,Benita!D2:D59,"New",[Benita!D2:D59,"Identified"])

Formulas and Functions

OliverScheurich
Feb 13, 2023
dgerdts
=SUMPRODUCT(SUMIFS(M2:M59,D2:D59,{"New","Identified"}))
You can try this formula.

OliverScheurich

Gold Contributor

Feb 13, 2023

dgerdts

=SUMPRODUCT(SUMIFS(M2:M59,D2:D59,{"New","Identified"}))

You can try this formula.

dgerdts

Copper Contributor

Feb 13, 2023

Works great - thank you!