| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average non continguous cells, excluding zero's
I am trying to average cells that are non contingous, and also need to
exlcude any zero's in the mix. All the posts I have read count on either sumproduct or countif both of which don't seem to be able to accept non contingous cells. Is there something that might be able to help. An example of the simple average formula is =AVERAGE(E92,E71,E50,E29,E8) Thanks, Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| How do I use an average function, not counting cells containing a | Excel Worksheet Functions | |||
| average of spaced cells | Excel Worksheet Functions | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Threaded Mode
