Forum Discussion

Oster980's avatar
Oster980
Copper Contributor
Sep 16, 2022

Formula Help

Hi, I am trying to create a formula. So what I need it to do for example is this;

 

If D2:D25 = Range 3 to 21 then take value in next column and add it to SUM

 

So if D3 = 5 and E3 = 25 then add E3 to SUM, and D2 = 15 and E2 = 15 then add E2, but if D4 = 1 then the value from E4 will not be added to the SUM. I can try to provide more context if needed.

excel
Formulas and Functions
  • Oster980's avatar
    Oster980
    Copper Contributor
    Sep 17, 2022

    I've tried =SUMIFS, =SUM, =FILTER, but I am not sure how to properly do this with the criteria. I am not very good with excel in general so any help on what formula I can use is greatly appreciated.

Resources