| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to average random cells with out counting zero?
=(A1+A8+A16+A24)/((A1<0)+(A8<0)+(A16<0)+(A24<0)) -- Gary''s Student - gsnu200850 "Alex" wrote: I am trying to average every 8th cell in a column, however I do not want to average zeros, =AVERAGE((IF(A1=0,"",A1)),(IF(A8=0,"",A8)),(IF(A16 =0,"",A16)),(IF(A24=0,"",A24))) is what I came up with but it gives the "#value" error! Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Months to get an Average | Excel Worksheet Functions | |||
| counting random occurrences | Excel Discussion (Misc queries) | |||
| Average formula Counting zero's How do I get just the numers counted. | Excel Discussion (Misc queries) | |||
| Average of a row of numbers not counting 0's | Excel Worksheet Functions | |||
| How do I use an average function, not counting cells containing a | Excel Worksheet Functions | |||
Threaded Mode
