Column B of my spreadsheet has the number of miles I run each day. Column A of my worksheet as the dates in the year I have run. So A1 might be 1/1/17, A2 would be 1/2/17 if I ran on 1/2. Otherwise, A2 would be the next day I ran - say 1/4/17.
To the side I have an other columns January - December. Next to each month I know have a blank cell. I want the number of miles I have run each month next to the name of the month. Is there a formula I could use for each month? I just can’t do an adding of all columns A1-A31 (for January) as I do not run each day. A31 would probably give me a date around Feb 10th.
TIA.
Bookmarks