| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to average a column, but exclude zero AND negative values?
I used the formula of =AVG(IF(A1:A10)<0,A1:A10)) to exclude just the zero
values, but what about zero AND Negative? Thanks!! |
|
#2
|
|||
|
|||
|
=AVerage(IF(A1:A10)0,A1:A10))
Still array entered. KMHarpe wrote: I used the formula of =AVG(IF(A1:A10)<0,A1:A10)) to exclude just the zero values, but what about zero AND Negative? Thanks!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
