usnapoleon
Board Regular
- Joined
- May 22, 2014
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
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?
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?