Hi all,

Many thanks in advance for your help.

I wish to take an average of every 4th cell in a column--I've tried a few things that haven't panned out. Essentially, I have quarterly data for a number of years, and I wish to have cross-year averages of Q1, Q2, Q3, and Q4. The quarters are in column A, with a repeating Q1,Q2,Q3,Q4 pattern, the data are in column B. I'm looking for a formula, not a pivot table.

Thanks again.