Incorrect addition

  • Thread starter Thread starter edrachel
  • Start date Start date
E

edrachel

I have checked all the forums and can not find an answer to my problem
so here is my post.

I am trying to add up different columns. My formula is:
=sum(d1:d90,e1:e90,f1:f90)

All of these cells either have a number or a zero. The number or th
zero is being pulled from another worksheet. The numbers and zeros ar
pulled and show correctly, but for whatever reason, some of the number
are being doubled or added twice to the total. Examble: If I have
12 showing and remove it, it will take 24 away from the total. Addin
it back will add 24 not 12. Not all of the numbers in any singl
column are being doubled, just some of the numbers. If it was th
whole column, I would assume that my formula was wrong, but when it i
just some of the numbers??? I am at a loss. If I add each colum
separately (sub-total) and then do a formula to add them together fo
the total:
=sum(d91+e91+f91)
it all adds up correctly. Each column is correct and the total i
correct. What am I doing wrong??? You help will be greatl
appreciated. Thanks.
:
 
edrachel wrote...
...
I am trying to add up different columns. My formula is:
=sum(d1:d90,f1:f90,u1:u90)
Click to expand...
...

Show your ACTUAL formula. You wrote the formula above in your pos
rather than copying it from Excel's formula bar and pasting it int
your post. Excel would have capitalized all letters in the formul
above.

Without seeing your ACTUAL formula it's just not possible to say wha
could be going wrong.

And follow up with a NEW message. Don't use excelforum's edit feature
 
You could check to make sure that all cells have the same format -
have found myself in the past that if format are different, you canno
depend on the summing feature. Also different formats work differen
ways and therefore add differently. Play around and see what you ca
figure out.
I also remember my boss telling me one day about a time he had t
muliply everything by one and so a paste special. Unfortunatey im no
sure if this will help you - maybe it will trigger someone elses memor
though.....
Good luck
 
Your boss had some character strings that only looked like numbers. The
Paste Special trick is a routine method for coercing text to numbers.
The OP already has numbers, else deleting them would not change the sum.
Harlan has probably hit on the problem: there is likely an undetected
redundancy in the formula that is not detectable in the post since the
OP retyped the formula instead of pasting it from Excel.

Jerry
 
Back
Top