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 🙂

​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 🙂    Read More

​