Average every 4th cell?

[uhhhhhhhhben]

I'm trying to average the data from every 4th column between the ranges C4:AY4

I've tried using the formula {=AVERAGE(IF(MOD(C4:AY4),4)=3, IF(...) } but I can't seem to figure out how to complete the last bit of the formula

Any solutions would be great even if it doesn't use that formula. Thanks

 

[kevin9999]

Does This help? I think it could be adapted to your needs.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=AVERAGE(FILTER(C4:AY4,MOD(COLUMN(C4:AY4),4)=3))

 

[turnerrc]

I am trying to do similar but with every 7th cell in a row. I assume the function would look like
=AVERAGE(FILTER(C4:AY4,MOD(COLUMN(C4:AY4),7)=6))
but it gives me a number that does not reflect the average based on manually averaging each cell.

 

[Fluff]

Which columns are you trying to average?

 

[turnerrc]

In my example above I was using the OPs cells range for simplicity's sake.
I am looking at a years worth of daily volume data that is all presented in a single row ( so 365 cells total in the row)
I am looking to find the average for each day of the week(why I need every 7 cell) by quarter and then for the entire year.
Currently, my first quarter cell range is B3:CH3 which would correspond to the first Saturday of the quarter and the last Saturday of the quarter.
The full cell range representing the year is B3:NB3

 

[Fluff]

That doesn't answer my question.
If you wanted to average columns B, I, P etc you would use

=AVERAGE(FILTER(B3:NB3,MOD(COLUMN(B3:NB3),7)=2))

 

[turnerrc]

Correct, if I want to find the average of every Saturday in the first quarter, B3 is the first Saturday and NB3 is the last Saturday of the first quarter.
So I would need to average row 3 in columns =AVERAGE(B3,I3,P3,W3,AD3,AK3,AR3,AY3,BF3,BM3,BT3,CA3,CH3)
If I want to do the same for Monday D3:CJ3
I would need to average row 3 in columns =AVERAGE(D3,K3,R3,Y3,AF3,AM3,AT3,BA3,BH3,BO3,BV3,CC3,CJ3)

 

[Fluff]

For Monday just change the 2 to 4

 

[turnerrc]

Thank you so much.