Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scw1217
 
Posts: n/a
Default Formula Help


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