I responded to your post, not the OP's. Your posted concern was that
Dave Patterson's formula treated empty cells as zeros. My post resolves
that.

Jerry

Ragdyer wrote:

Jerry,
Follow this scenario:
A1:A10
5,-6,2,13,2,-3,25,mt,mt,mt
OP's request - Average as if all numbers were positive.
Sum would equal 56.
Average would equal 8.

Your formula yields 9.4

Same scenario,
Dave's formulas return 5.6 - 5.875 - 9.4