Forum Discussion
Solved
Include subtract condition in formula
The following formula requires the subtraction condition included in the formula
=SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23)
The value 14.09 will be hard coded into the formula
Here is my poor attempt to modify the above formula
=SUMIFS((Trades!$O$5:$O$999, Trades!$R$5:$R$999, D23 ),-14.09)
How about this:
=SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23) - 14.09
5 Replies
Hi there,
I have included a sample workbook which should better explain what I need.
Thanks
https://1drv.ms/x/c/7f92b59c367af02d/EZ8ProceNAZNtJAOGengD5sBS21Gxovia990lSZDHqwTtQ?e=1Vg8ju
I'm afraid your workbook doesn't make it any clearer. Please explain in words what you want to accomplish.
How about this:
=SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23) - 14.09simple solution, that will do nicely.
Thanks guys
Please explain what you want to subtract 14.09 from.
- From each value in O5:O999 that matches the condition?
- From D23?
- From the result of SUMIFS?
- Something else - if so, what?
