SumIf formula help

[usnapoleon]

Hello everyone
I have this existing formula:

=SUMIFS($N$21:$N$57,$H$21:$H$57,M4,$M$21:$M$57,N4)

It works perfect, adding up whatever is in column N. What if I wanted it to continue doing that but subtract what is in column O too?

There is a long and ugly way of just inputting another round of sumifs to it, for the subtraction of column O like this:

=SUMIFS($N$21:$N$57,$H$21:$H$57,M4,$M$21:$M$57,N4)-SUMIFS($O$21:$O$57,$H$21:$H$57,M4,$M$21:$M$57,N4)

Is there a prettier way to do this?

 

[Cubist]

Try

=SUM(FILTER($N$21:$N$57-$O$21:$O$57,($H$21:$H$57=M4)*($M$21:$M$57=N4)))

 

[usnapoleon]

Try

=SUM(FILTER($N$21:$N$57-$O$21:$O$57,($H$21:$H$57=M4)*($M$21:$M$57=N4)))

That works! I added the extra for an empty filter. Works perfect! I knew there was something less messy! Thank you!

 

[Cubist]

You're welcome. Cheers.