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...
How about this:
=SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23) - 14.09
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?
