Forum Discussion

dgerdts's avatar
dgerdts
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's avatar
    OliverScheurich
    Feb 13, 2023

    dgerdts 

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

    You can try this formula.

     

dgerdts's avatar
dgerdts
Copper Contributor
Feb 13, 2023
I also tried with COUNTIFS but it doesn't work?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 13, 2023

dgerdts 

Do you mean

=SUM( COUNTIFS(D2:D59,{"New","Identified"}) )

or

=SUM(COUNTIFS(M2:M59, "<>", D2:D59,{"New","Identified"}))

?