"SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT

[EXCEL STATS USER]

I AM DOING CAREER STATS FOR PLAYERS. EACH ROW IS 1 SEASON, WITH A "CAREER
TOTALS" ROW BENEATH THAT, USING THE "SUM" FUNCTION FOR EACH COLUMN. WHEN I
ADD THE LATEST SEASON ABOVE THE "CAREER TOTALS" ROW, THE "SUM" FUNCTION DOES
NOT INCLUDE ALL OF THE ROWS ABOVE IT. IT USUALLY LEAVES THE TOP ROW OUT. HOW
DO I GET THE "SUM" FUNCTION TO INCLUDE ALL OF THAT SPECIFIC PLAYERS' ROWS?
THANKS FOR YOUR HELP

 

[Praburam]

I AM DOING CAREER STATS FOR PLAYERS. EACH ROW IS 1 SEASON, WITH A "CAREER
TOTALS" ROW BENEATH THAT, USING THE "SUM" FUNCTION FOR EACH COLUMN. WHEN I
ADD THE LATEST SEASON ABOVE THE "CAREER TOTALS" ROW, THE "SUM" FUNCTION DOES
NOT INCLUDE ALL OF THE ROWS ABOVE IT. IT USUALLY LEAVES THE TOP ROW OUT. HOW
DO I GET THE "SUM" FUNCTION TO INCLUDE ALL OF THAT SPECIFIC PLAYERS' ROWS?
THANKS FOR YOUR HELP

Hi,

If you ada a cell preceeding to the Total cell means it will
automatically add the above given cells.

Ok.. now try this:
Type the formula as:

=SUM($A$2:A7)

In the above fomula i have locked the topmost data of my column. So,
now onwards your starting cell will be constant and other will be
variable according to ur need.

Thanks and Regards,

S. Praburam

 

[Gord Dibben]

Please drop the all CAPS. Hard to read and looks like shouting.

Enter this formula to sum the totals in Column A.

=SUM(A1:INDEX(A:A,ROW()-1))

Will deal with inserted rows above the formula.

Drag/copy across to other columns


Gord Dibben MS Excel MVP

On Sun, 13 Jan 2008 09:50:01 -0800, EXCEL STATS USER <EXCEL STATS

 

[Sandy Mann]

Please don't post in all upper case text - it makes your post harder to
read.

Try in A8 enter:

=SUM($A$1:OFFSET(A8,-1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk