Prev: Follow up question about consolidating dups and sums
Next: MS excell 2007 Data verification list
From: mlv on 3 Apr 2010 13:34
When adding a column of numbers, the sum function failed to accurately sum
the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How do I
correct this internal error?
From: Paul on 3 Apr 2010 13:40

What formula are you using to sum those cells/values? If those values
are in A1:A4, you should be using

=SUM(A1:A4)

Are you perhaps using

=SUM(A1,A4) ?

(which, in this case would actually equal 1900).




m
l
v
;
6
8
9
5
4
1

W
r
o
t
e
:


>
When adding a column of numbers, the sum function failed to accurately
sum
> the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How
do I
> correct this internal error?


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192699

http://www.thecodecage.com/forumz

From: Arvi Laanemets on 3 Apr 2010 14:14
Hi

1200 and one of 700 are numbers, another 700 and 800 are texts.

1.Format the range with your numbers as numeric or general;
2. Into some empty unformatted cell somewhere enter a number 1, and copy the
cell;
3. Select the range with your numbers, and Paste Special as Multiply - now
your formula must return right result;
4. Clear the cell you used to store number 1.


Arvi Laanemets


"mlv" <mlv(a)discussions.microsoft.com> wrote in message
news:90D9A9E8-73CE-4E44-AA96-423A26875C8B(a)microsoft.com...
> When adding a column of numbers, the sum function failed to accurately sum
> the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How do
> I
> correct this internal error?


 | 
Pages: 1
Prev: Follow up question about consolidating dups and sums
Next: MS excell 2007 Data verification list