sum up 2 different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=D5-SUM(D6:D92,H6:H92) i thought worked but i guess it doesn't cant anyone
help me
 
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)
 
i'm running 2002 i think. but for some reason my formula won't work anymore.
got any suggestions
 
What doesn't work? Does it give you the wrong total, or are you
getting error messages?
 
worng totals, first column works fine but when i add or subract an amount
form the second column the total doen't change
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why is this not working? 6
SUMIF with NAME RANGE 1
Does anyone have aformula for Weeks Supply? 1
sum formula does not calculate 3
Complex Question on Filtering on a merged column 1
Help !!! 2
setting excel formula from code 4
How to sum the last 7 number in a row? 6

Back
Top