Average every 3rd cell in a row

[liselbez]

Hi I need some help please,

From other treads I have identified the formula below:
=AVERAGE(IF(MOD(COLUMN(H4:XFD4),3)=2,IF(H4:XFD4<>"",H4:XFD4)))

BUT, 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?

Then next step how do I average every 3rd cell on a row across 4 rows?

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Looks like you want to average the values in the 'Deviation' columns. If that is so, try this structure

23 11 09.xlsm
	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Deviation	P/F	Measurement	Deviation	P/F	Measurement	Deviation	P/F	Measurement	Deviation	P/F	Measurement	Average Deviation
2	4	Pass	2	7	Pass	2	5	Fail	3	2	Pass	8	4.5
3	9	Fail	8	2	Pass	3	1	Pass	6	5	Pass	7	4.25
4	2	Fail	5	8	Fail	4	3	Fail	5	3	Pass	5	4
5	3	Pass	6	2	Pass	5	7	Fail	2	6	Fail	1	4.5
Average

Cell Formulas
Range	Formula
S2:S5	S2	=AVERAGEIFS(G2:R2,G$1:R$1,"D*")