| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average not including Zeros/Blanks
I am using the following formula for an average function, but it doesn't
quite do what I need it to do. =AVERAGE(IF(F3:F38<0,F3:F37)) There are cells in this that I need to omit from the average, because they are a subtotaled average for the week. I need to somehow remove F10, F18, F26, F34, and F38 while the formula still calculates the average for the cells that have information in them, omitting the blank cells. I did some looking around on the forum (that's where I got the above formula) and didn't find anything that would fit. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas blanks vs zeros | Excel Discussion (Misc queries) | |||
| Fomat cells for IP address including leading Zeros | Excel Worksheet Functions | |||
| lookup on Table including blanks - | Excel Worksheet Functions | |||
| in excel, how do i get an average without including the zeros? | Excel Worksheet Functions | |||
| How do I average a column without including zeros | Excel Discussion (Misc queries) | |||
Threaded Mode
