| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average non-adjacent cells & exclude zeros
I want to find an average of three cells that are non-adjacent and will
occasionally have a zero in it. Example: =AVERAGE(H12,V12,AJ12) How can I rewrite this so that the formula will not include the cell in the average if its value is zero? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Non-Adjacent Cells in Budget Spreadsheet | Excel Worksheet Functions | |||
| Average Non-Adjacent Cells in Budget Spreadsheet | Excel Worksheet Functions | |||
| Another Average non-adjacent cells question... | Excel Discussion (Misc queries) | |||
| Average non-adjacent cells if the cell does not contain zero | Excel Discussion (Misc queries) | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
Threaded Mode
