| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i average only certain cells
oks o i have a row of information but to keep this simple here it is
a1 b1 c1 d1 e1 f1 g1 h1 i1 5 2.5 5 2.3 0 2.4 4 2.8 7 i need to average the cells a1,c1,e1,g1,and i1 b1,d1,f1,g1 is info i dont need so to skip or ignore these values also i need the average of a1,c1,e1,g1,and i1 while ignoreing the zeros thanks - RG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I average cells | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| average 2 cells (Mileage Divide by Gallons in two cells | Excel Discussion (Misc queries) | |||
Threaded Mode
