| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate average from non contiguous column, ignoring (0) values
I'm using Office 2003. I have a need to have 0 in a range of cells (instead
of blank). I need to create an average from some non contiguous cells. I want the average to ignore cells containing a 0. I can have the formula | =IF(B2=0,"",B2) | and if b2 is 0 then the formula returns a blank, and if b2 is < 0 then formula returns value from b2. If I embed this If formula into an Average formula | =AVERAGE(IF(B2=0,"",B2),B9,B16,B23) | it returns a #Value error. How can I create an Average formula that ignores cells with 0 value? -- Jesse |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Contiguous Values in a Column? | Excel Discussion (Misc queries) | |||
| average of different cells ignoring zero values | Excel Discussion (Misc queries) | |||
| how to calculate average value in a row ignoring values below "x" | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
Threaded Mode
