JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
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
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