My wife and I developed a basic spreadsheet with which my supervisor could keep track of monthly statistical information for a monthly report he needs to generate. The spreadsheet adds and averages certain columns of information. What I’d like for the sheet to do is to provide just as many rows as may be needed on any given month. Some months he may have 20 or so rows of data and yet on others he may have 30 or more.
Is there a way to have such a spreadsheet that will add rows as needed and just sum and average those columns that are used? Right now, to ensure my boss has enough rows/columns to handle the amount of data he might have in any given month, I am providing about 25 rows on the sheet. This past month the amount of stats required more capacity so he just used two of the sheets. I’d like for him to be able to just keep adding info as needed and, at the end of the month, the sheet will have his running totals & averages at the bottom without a bunch of empty rows in between the last entry and the final totals/averages.
Just FYI, for those who may be curious, this sheet is to compute motor vehicle collision stats (drivers’ ages, damage estimates, etc.) for my supervisor to present to the Chief of Police monthly. A copy of the spreadsheet is attached
