Forum Discussion

packie's avatar
packie
Brass Contributor
Dec 10, 2024

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

     

    • 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

     

    • packie's avatar
      packie
      Brass 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?

Resources