Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Averaging noncontiguous numbers ignoring zeros?
Averaging noncontiguous numbers ignoring zeros?
I'm trying to calculate an average but I want to not include any values of zero. I've seen examples here and in Microsft help for contiguous values (ex: A1:A7) but not for the averages of noncontiguous data (ex: A1, A3, A5). I found Microsoft's example using contiguous data under "Calculate the average of numbers, ignoring zero (0) values". They show how to average A1:A6 using: =AVERAGE(IF(A2:A7<0, A2:A7,"")) . I've not been able to revise this formula to calculate noncontiguous data. Any ideas? -- Cheers, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging, ignoring zeros | Excel Worksheet Functions | |||
Averaging numbers but ignoring < and - entries | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) |