Average every 3rd column in a row

[JTL9161]

I am trying to average every 3rd cell in a row starting B then F, I,...etc. to BH.

I am using this =AVERAGE(IF(MOD(COLUMN(B$38:BH$38),3)=0,B$38:BH$38,"")) but when answer should be 100 i am getting 10

Thanks,
James

 

[Fluff]

Every 3rd cell starting at B would be B, E, H. Not B, F, I.
If it should be B,E H etc then the Mod should =2 not 0

 

[JTL9161]

What would it be for B, F, I, L.... I am using the one i entered abovie

 

[Fluff]

But B to F is 4 columns & the others are 3 columns.

 

[JTL9161]

Duh! Sorry on meds. C instead of B

 

[Fluff]

Ok, how about

=AVERAGE(FILTER(B$38:BH$38,MOD(COLUMN(B$38:BH$38),3)=0))

 

[JTL9161]

Perfect. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.