| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average with out zeros or blanks
I'm trying to average a set of cells that are not continuous and would like to get an average as long as the cell is not zero or empty. Here are the cells I'm looking to average. Currently I'm using an average option but it will not give me an average unless all five cells are filled
=AVERAGE(E137,E163,E189,E215,E241) I heard there is a countif and sum option or something like that but I get too many arguments when trying to use it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Multiple Worksheets without blanks or zeros | Excel Discussion (Misc queries) | |||
| Counting blanks as zeros | Excel Worksheet Functions | |||
| Average not including Zeros/Blanks | Excel Worksheet Functions | |||
| Vlookup blanks = zeros | Excel Discussion (Misc queries) | |||
| Blanks chart as zeros | Charts and Charting in Excel | |||
Threaded Mode
