average every 3rd cell in a row

[jproffer]

Hi ladies and gents

I've searched some and found some solutions to averaging every nth cell in a row or column, but haven't been able to take the given solutions and modify them to what I'm doing.

Anyway, on to the point....

I'm trying to average every 3rd cell, in my case from H4:XFD4, starting with H4...in other words average H4, K4, N4, Q4, T4, W4, Z4....etc, to the end of the worksheet, and ignoring blanks (I already have the contributing formulas set up to be blank if that week doesn't yet have data). And hopefully (presumably, like every other formula in excel) I'd be able to drag/copy it down a few rows.

I found something like this, but I THINK (even though I can't decipher much of it beyond "average" and "if") this averages every 5th cell in a column, going down. I couldn't figure out how to change it to "every 3 in a row".

=AVERAGE(IF((MOD(ROW(D2:D2353)-ROW(D2)+1,5))=0,IF(D2:D2353<>"",D2:D2353)))



Thanks in advance for any help.

 

[Peter_SSs]

Hi, how do you get the formula to start counting at a specific cell nr. So if I need the formula to take the average of every 3rd cell starting at column I how do I incorporate that into the formula?

This appears to be a duplicate of Average every 3rd cell in a row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this older thread so please continue in the linked thread.