Forum Discussion

packie's avatar
packie
Brass Contributor
Dec 10, 2024
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...
excel
Formulas and Functions
  • Kidd_Ip's avatar
    Kidd_Ip
    Dec 11, 2024

    How about this:

     

    =SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23) - 14.09

     

Kidd_Ip's avatar
Kidd_Ip
MVP
Dec 11, 2024

How about this:

 

=SUMIFS(Sheet1!$O$5:$O$999, Sheet1!$R$5:$R$999, D23) - 14.09

 

packie's avatar
packie
Brass Contributor
Dec 12, 2024

simple solution, that will do nicely.

Thanks guys

Resources