Average of any numbers above 0 and bellow 0?

PhilipeC

Board Regular
Joined
May 1, 2018
Messages
56
Formula to find the average of any numbers above 0 and bellow 0 from H4:20, only numbers above 0 and bellow 0 are averaged?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

PhilipeC

Board Regular
Joined
May 1, 2018
Messages
56
I tried but i want the total average of all the positive numbers above 0 and bellow 0 from H4:H20, so the cells with 0 wont be counted.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,984
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top