I am doing statistics for a sports league. I have each player sorted by last
name, then 1st name, then year played.
At the end of a season, I copy & paste each player's stat line from a
separate workbook into the end of my main file.
Each player has a TOTALS line which is determined by using AUTOSUM for each
column necessary. When I try to sort the page by the criteria I mentioned
above,
the AUTOSUM results do not include all years played.
For example, ROW 1 thru 5 is SMITH, JOE. The years are 1999, 2000, 2001,
2002, 2003. The AUTOSUM results in each column is "=sum(row1:row5).
When I add year 2004 & try to sort , the result of AUTOSUM in each column is
"=sum(row2:row6)". It should be "=sum(row1:row6).
How can I force AUTOSUM (or any SUM function) to include a SORTED row in its
calculations?