Forum Discussion
Rolling MTD Average
Hello I have been searching throughout the day for a way to create a FORMULA that will return the MTD average on each day. EX: Jan 1 = 10 Jan 2 = 20 and Jan 3 = 30..... This would make the MTD AVG ...
No special function needed. Just use an absolute reference at one end and a relative reference at the other.
Something like =AVERAGE($A1:B1) and copy that across the columns. Assuming, obviously, that your days are arranged across the various columns