| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I average cells if a cell is at #div/0!
ok heres what I have.
in cell D6 I have formula of =AVERAGE(D7:D10) which its at #div/0! in cell D11 = AVERAGE(D12:D15) which its at 85 in cell D16 =AVERAGE(D17:D210) which its at 50 in cell D3 I just want the average of cell D6,D11,and D16 is this possible and how? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
| Average non-adjacent cells if the cell does not contain zero | Excel Discussion (Misc queries) | |||
Threaded Mode
