AverageIf

[larryg003]

Hi guys,

I have a column "A" of data which has negative, positive and zero values.
I only want to average the values that are negative and positive.

In B1 I wrote: =averageif(A1:A200, <>0, A1:A200)
and it didn't work. Any thoughts?

Thanks a lot!

[ConneXionLost]

Try this:

Please Login or Register  to view this content.

Cheers,

[Marcol]

Try in B1

Please Login or Register  to view this content.

or just

Please Login or Register  to view this content.