Forum Discussion
Challenging Excel SUM.IF with filter
Hi community.
I have trouble with filtering SUM.IF.
If "÷" is shown in the coloumn "Rejceted by advisor", it is correct to add the specific number to cell D10.
But If "÷" is shown in the coloumn "Rejceted by advisor" and the coloumn "Responsible" is shown "dicontinued", D10 should not add the specific number - only E11 should.
What kind of formula must be used??
I hope it makes sense, and hope for help 🙂
Use SUM.HVISER. To sum the values for which column D contains ÷ and column E contains Discontinued:
=SUM.HVISER(C4:C7; D4:D7; "÷"; E4:E7; "Discontinued")
And to sum the values for which column D contains ÷ and column E does not contain Discontinued:
=SUM.HVISER(C4:C7; D4:D7; "÷"; E4:E7; "<>Discontinued")
1 Reply
Use SUM.HVISER. To sum the values for which column D contains ÷ and column E contains Discontinued:
=SUM.HVISER(C4:C7; D4:D7; "÷"; E4:E7; "Discontinued")
And to sum the values for which column D contains ÷ and column E does not contain Discontinued:
=SUM.HVISER(C4:C7; D4:D7; "÷"; E4:E7; "<>Discontinued")