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!
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!
Try this:
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Try in B1
or justPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Marcol; 06-19-2010 at 07:34 PM. Reason: To much beer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks