View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EXCEL STATS USER EXCEL STATS USER is offline
external usenet poster
 
Posts: 1
Default "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