Find the average of all the positive numbers above 0 and bellow 0 from H4:H20, so the cells with 0 wont be counted

[PhilipeC]

How to find the average of all the positive numbers above 0 and bellow 0 from H4:H20, so the cells with 0 wont be counted?

 

[mikerickson]

Try
=AVERAGEIF(H4:H20,"<>0")

 

[PhilipeC]

It didnt work, the result were a random number.

 

[footoo]

https://www.google.com.hk/search?sa...j33i22i29i30k1j33i160k1j33i21k1.0.0zVqNWi4jp8

 

[footoo]

Duplicate post : https://www.mrexcel.com/forum/excel-questions/1062317-average-any-numbers-above-0-bellow-0-a.html

 

[Macropod]

PhilipeC : As per Forum Rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), kindly don't start multiple threads on the same topic.
Thread closed. You may continue the discussion in your original thread.