Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Average
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Calculate Average | Excel Discussion (Misc queries) | |||
How do I calculate an average if | Excel Discussion (Misc queries) | |||
CALCULATE WITH AVERAGE ???? | Excel Discussion (Misc queries) | |||
If/Then calculate the average | Excel Worksheet Functions | |||
I want to calculate the average of best 5 out of 7 numbers? | Excel Discussion (Misc queries) |