Average header if range fits condition

[cyrilbrd]

1	2	3	4	5	6	7	8
x
	x
		x
		x
						x
					x
						x
							x

<tbody>
</tbody>

Given the above, the results should be 4.625

 

[steve the fish]

Try this:

=SUMPRODUCT((A2:H9="x")*A1:H1)/SUMPRODUCT(--(A2:H9="x"))