| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging only populated cells
I'm averaging cells that aren't next to each other, but i don't want the
average to include cells that aren't populated. =AVERAGE(F4:F6,F10,F14,F18,F21) f F4- 5 F6- 5 F10- F 14- 5 AVERAGE = 3.75 for example, its possible that, let say, F10 has no quantitiy, i don't want that to drag my average down. I want the results in the example above to average = 5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy to new cells if populated | Excel Discussion (Misc queries) | |||
| Cells to be populated from an workbook to another. | Excel Discussion (Misc queries) | |||
| Counting populated cells in another worksheet | Excel Worksheet Functions | |||
| changing average if cells populated | Excel Worksheet Functions | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Threaded Mode
