# USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100

Copper Contributor

# 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

# Re: USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100

I'm not sure I understand your question. Do you want the result in B2 or in another cell?

# Re: USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100

Hi Hans, Sorry, Yes I want the result to be in B2.

# Re: USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100

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)

# Re: USING SUM FUNCTION FOR MULTIPLE COLUMNS TO ADD OR SUBTRACT FROM A STARTING VALUE OF 100

The alternative worked PERFECTLY! Thank you very much Hans! I appreciate you!