Hi ub,

Try:
=(((A10)+(A80)0)*C1+((A40)+(A80)0)*C4+C6)/(((A10)+(A80)0)+((A40)+(A80)0)+1)

--
Cheers
macropod
[MVP - Microsoft Word]


"ub" wrote in message ...
Hi
I have data in my sheet as

Row# Column A Column B Column C
1 20 0 20
2 Row # 2 has some other data
3 row # 3 has some other data
4 21 20 15
5 row#5 has some other data
6 20 0 15
----------------------------------------------------------------
8 Total- 61 20 50
----------------------------------------------------------------
I want to take the average of c1, c4, c6 with the condition that cell c1
should be counted in average if cell a10 or a80, similarly cell c4 should
be counted in average if cell a40 or a80

Thanks