| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i get an average that ignores blanks in the range of cells.
i am trying to average a range of cells, in different spreadsheets within one
worksheet but it gives me the error #div/0 when one of the cells is blank. Any suggestions, thoughts, comments? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Threaded Mode
