I'm trying to build a spreadsheet that averages Blood Glucose readings.
I have the formulae for the averages, weekly, monthly and annually.
January is on one worksheet, February on another and so on.
I'm hitting a brick wall when I try to collect the monthly data from each month and place it in a YTD worksheet.
There will be 13 worksheets under one file.
I'd like to have YTD be dynamic and update each time I input new data.
This is for my own use.
Thanks in advance.
Bookmarks