I’m trying to create a 5 week average formula. However, every formula that I create seems to change by one row when I add in new data for the week. I want the same 5 rows that I originally selected to stay the same even when I add an additional row. I’ve tried adding in the $ sign at various places to keep the row the same, but it does not work. Any suggestions? I’m not sure if I need to add in an index or indirect command into the formula?
By: E.J. Thomas