Forum Discussion
packie
Dec 10, 2024Brass Contributor
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
- packieBrass Contributor
Hi there,
I have included a sample workbook which should better explain what I need.
Thanks
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.09
- packieBrass Contributor
simple 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?