Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
On Jan 13, 10:50*pm, EXCEL STATS USER <EXCEL STATS
wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
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 wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
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 Replace @mailinator.com with @tiscali.co.uk "EXCEL STATS USER" <EXCEL STATS wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |