Need help with this formula.

Question

I have this formula so far.&nbsp; It works correctly to add the values in the range ($F$7:$F$110) when the cells in the range ($C$7:$C$110=C112) but I also need it to subtract the values in the range F if the criteria range C is equal to C113 rather than the C112. in the same formula.&nbsp; Any help would be appreciated thank you in advance.&nbsp;=L57+SUMPRODUCT(($C$7:$C$110=C112)*$F$7:$F$110)

hansvogelaar · Answer

jakuzi1&nbsp;
Perhaps
&nbsp;
=L57+SUMIFS($F$7:$F$110, $C$7:$C$110, C112)-SUMIFS($F$7:$F$110, $C$7:$C$110, C113)

jakuzi1 · Answer

thank you but the formula did not work. It only subtracted the values in range f7:f110. It did not start with the original value L57 nor did it add any of the values it needed to add in range f7f110.

hansvogelaar · Answer

jakuzi1&nbsp;
Apparently I don't understand what you want.
Could you provide an example that shows what you want the formula to do?

jakuzi1 · Answer

HansVogelaar&nbsp;Thanks for your help.&nbsp; I do not know how to attach my workbook to this forum, but I was able to receive help from another form and I have the solutions now.&nbsp; The below formula does what I wanted and its much simpler than what I started with.=L15+SUM((IF(C7:C110=C112,1,-1))*F7:F110)&nbsp;

hansvogelaar · Answer

jakuzi1&nbsp;
I'm glad you have something that suits you, but that formula solves a different problem than what you asked in your first post.

Forum Discussion

Need help with this formula.

5 Replies

Resources