Average score selected by colour

[Raggy]

I have a seriea of scores I want to just find the average of, not thats simple enough but sometimes there is not a score.

As shown above I want to just colour the cells that dont have a score rather than enter 0 as it helps me to spot patterns etc. How can I get excel to automaticaly only count the cells that are a certain colour in that row and then find the average of those cells?
Hope I have made myself clear.

 

[Peter_SSs]

Perhaps I am not understanding your description, but if you leave out those coloured '0' values then Excel will ignore them for the average calculation (whether or not you colour them).

BTW, I 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.

20 10 19.xlsm
	A	B	C	D	E	F
1						Average
2
3	42	27	25	31	0	25.0
4					0	0.0
5	41	34	31	20	0	25.2
6
7	37	36	31	43	0	29.4
8
9	27	41	33		0	25.3
Average

Cell Formulas
Range	Formula
F2:F9	F2	=IF(COUNT(A2:E2),AVERAGE(A2:E2),"")

 

[Raggy]

Thanks, solves my problem exactly.

 

[Peter_SSs]

Thanks, solves my problem exactly.

Cheers. Thanks for the confirmation.