=(I2 + H3) - SUM((A3:G3)

is as easy as any

Should that be I2 or I3?


--

HTH

RP

"scw1217" wrote in
message ...

I have 6 columns, A through G. Each contains a currency expense, or
debit. Column H is deposits. Column I is my balance. I need to add
column H to column I, and subtract from this figure the total value of
columns A-G. Something like this:

I2 + H3 - (A3+B3+C3+D3+E3+F3+G3)

What is the proper formula, or can it not be done in one cell? Thanks.


--
scw1217
------------------------------------------------------------------------
scw1217's Profile:
http://www.excelforum.com/member.php...fo&userid=2814
View this thread: http://www.excelforum.com/showthread...hreadid=502072