Creating a 5 week average formula that does not automatically move down when a row is added

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

One thought on “Creating a 5 week average formula that does not automatically move down when a row is added

Leave a Reply

Your email address will not be published. Required fields are marked *