Forum Discussion
USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100
Hello. How do I add and subtract multiple columns starting with a value of 100?
Column B2 will have 100 to start. Then I want to add OR subtract values that are plugged into D2, H2, L2 from B2 (100). I know I need to plug in positive or negative numbers to add or subtract, but how do I get that to work with adding or subtracting from B2 (100)?
4 Replies
I'm not sure I understand your question. Do you want the result in B2 or in another cell?
- Hi Hans, Sorry, Yes I want the result to be in B2.
It won't work quite that way. One option is to enter the start value in another cell, for example in A1.
In B1, enter the formula
=SUM(A1, D2, H2, L2)
Alternatively, include the value 100 in the formula instead of entering it in a cell:
=SUM(100, D2, H2, L2)
