U
ub
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 a1>0 or a8>0, similarly cell c4 should
be counted in average if cell a4>0 or a8>0
Thanks
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 a1>0 or a8>0, similarly cell c4 should
be counted in average if cell a4>0 or a8>0
Thanks