Will give you the average for F1:F60. When copied down one cell, it will give you the average for F61:F120, and so on. So basically, you enter this formula above and copy down. Just as easy as a macro. But if you don't want a formula, we can get a macro solution as well.