"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
|