additing and subtracting sum totals

GetReel

Registered User.
Local time
Today, 11:03
Joined
May 22, 2003
Messages
67
Havent used excel for a while so I am a bit rustly on formulas.
Im trying to create a running balance

I have 2 cell that i need to add. This part is fine..

=SUM(J29,C30) . This equal 111. Now I need to subtract the J29,C30, which 5 to give me 116.

I tried =Sum((J29,C30-J29,C30) but is didnt work for me.

How do I subtract the sum of D30:G30 from sum of (J29,C30)?
 
I'm struggling to understand your exact question, however....

Consider:
=SUM(J29,C30)

The above expression is using the SUM function. While it is not unreasonable to use the SUM function here, the SUM function really comes into its own when summing a range of cells. Instead, I would recommend (for clarity) using:
=J29+C30

Suppose you then want to subtract a cell then:

=J29+C30-E20


How do I subtract the sum of D30:G30 from sum of (J29,C30)?

When you say "sum of D30:G30" I assume you mean the sum of all four cells in the range? In which case the formula you are looking for would be:

=J29+C30-SUM(D30:G30)


hth
Chris
 
Sorry I should have made myself more clear.

=J29+C30-SUM(D30:G30) worked.

Thanks
 

Users who are viewing this thread

Back
Top Bottom