Formula Help

Copper Contributor

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.

1 Reply

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.