I have an Excel sheet in which col A contains numbers a1 = 1, a2 = 2, a3 = 3 etc etc.
Col B contains the dates, b1 = 6/1/21, b2 = 6/2/21 etc.
Col C contains the daily steps walked such as 9520, 8670 etc.
Col D contains the average daily step count.
On cell E1, I have the formula =INDEX(D:D,MATCH(TODAY(),B:B,0)) * INDEX(A:A,MATCH(TODAY(),B:B,0)) which gives the sum of the steps from 6/1/21 till today. How would I modify the formula to compute the average steps walked only in July of 21 updated automatically. Thank you for the time.
Col B contains the dates, b1 = 6/1/21, b2 = 6/2/21 etc.
Col C contains the daily steps walked such as 9520, 8670 etc.
Col D contains the average daily step count.
On cell E1, I have the formula =INDEX(D:D,MATCH(TODAY(),B:B,0)) * INDEX(A:A,MATCH(TODAY(),B:B,0)) which gives the sum of the steps from 6/1/21 till today. How would I modify the formula to compute the average steps walked only in July of 21 updated automatically. Thank you for the time.