sum up 2 different columns

J

Jarrod

Don't know what version of Excel you are using. I have 2003, put your formula
in pretty much exactly and it worked just fine. Here is mine.
=A14-SUM(A2:A11,B2:B11)
 
M

Michele

i'm running 2002 i think. but for some reason my formula won't work anymore.
got any suggestions
 
S

scott

What doesn't work? Does it give you the wrong total, or are you
getting error messages?
 
M

Michele

worng totals, first column works fine but when i add or subract an amount
form the second column the total doen't change
 
G

Gord Dibben

Michelle

Perhaps second column numbers are Text.

Format an empty cell as General.

Copy the cell and select your range of "numbers".

Paste Special>Add>OK>Esc.

Results are correct??

Gord Dibben Excel MVP
 
Top