Please see attached spreadsheet. I would like to have a formula or macro that computes the values for column B in sheet 2 of my spreadsheet. These values should be monthly averages of the daily values listed in column B of sheet 1. As an example, cell B2 in sheet 2 should = average(sheet1!B2:B23)
Bookmarks