I have a table (see below) that I totaled the first column using the sum
feature. The sum forumula is Sum(B4:B15) which equals 888,834. I copied this
cell and pasted to the next to columns and as you can see they have the same
total number, but the formula in the cells are Sum(C4:C15) and Sum(D4:D15). I
have copied the sum formula across columns before and it works and I have
never seen this. If I go to each column separtely and use the sum feature,
they do total correctly. Thanks for any help!


Jan 106,910 9,718,266 744
Feb 63,943 11,895,480 660
Mar 88,397 14,599,876 743
April 66,995 13,595,614 718
May 28,331 13,382,000 744
Jun 90,596 9,702,020 712
July 79,361 9,409,883 707
Aug 71,583 10,750,595 714
Sept 49,816 11,063,131 603
Oct 77,208 12,326,880 742
Nov 87,124 11,942,943 717
Dec 78,570 12,869,295 743
Total 888,834 888,834 888,834

Hit F9 to recalculate your sheet

"lalbay" wrote:

I have a table (see below) that I totaled the first column using the sum
feature. The sum forumula is Sum(B4:B15) which equals 888,834. I copied this
cell and pasted to the next to columns and as you can see they have the same
total number, but the formula in the cells are Sum(C4:C15) and Sum(D4:D15). I
have copied the sum formula across columns before and it works and I have
never seen this. If I go to each column separtely and use the sum feature,
they do total correctly. Thanks for any help!


Jan 106,910 9,718,266 744
Feb 63,943 11,895,480 660
Mar 88,397 14,599,876 743
April 66,995 13,595,614 718
May 28,331 13,382,000 744
Jun 90,596 9,702,020 712
July 79,361 9,409,883 707
Aug 71,583 10,750,595 714
Sept 49,816 11,063,131 603
Oct 77,208 12,326,880 742
Nov 87,124 11,942,943 717
Dec 78,570 12,869,295 743
Total 888,834 888,834 888,834

It sounds like you Manual Calculation turned on.

If you want the worksheet to automatically recalculate:

From the Excel main menu:
<tools<options<calculation tab
Check: Automatic

Otherwise, press the [F9] key to force recalculation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Michael" wrote:

Hit F9 to recalculate your sheet

"lalbay" wrote:

I have a table (see below) that I totaled the first column using the sum
feature. The sum forumula is Sum(B4:B15) which equals 888,834. I copied this
cell and pasted to the next to columns and as you can see they have the same
total number, but the formula in the cells are Sum(C4:C15) and Sum(D4:D15). I
have copied the sum formula across columns before and it works and I have
never seen this. If I go to each column separtely and use the sum feature,
they do total correctly. Thanks for any help!


Jan 106,910 9,718,266 744
Feb 63,943 11,895,480 660
Mar 88,397 14,599,876 743
April 66,995 13,595,614 718
May 28,331 13,382,000 744
Jun 90,596 9,702,020 712
July 79,361 9,409,883 707
Aug 71,583 10,750,595 714
Sept 49,816 11,063,131 603
Oct 77,208 12,326,880 742
Nov 87,124 11,942,943 717
Dec 78,570 12,869,295 743
Total 888,834 888,834 888,834