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

     

packie's avatar
packie
Brass Contributor
Dec 12, 2024

Hi there,

 

I have included a sample workbook which should better explain what I need.

 

Thanks

IncludeSubstract.xlsx

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 12, 2024

    I'm afraid your workbook doesn't make it any clearer. Please explain in words what you want to accomplish.

Resources