Column B is filled with numbers from b5 to b473. Each week a new number is added to the bottom. I need a formula to average every 4th number starting with b5. In other words, I need to average b5,b9,b13, and so on. Need to do the same with next set-b6,b10,b14,etc.
Any help is appreciated.
Any help is appreciated.