But Gerry's <VBG does answer the question in the subject--just not the question
in the body.



RagDyeR wrote:

<"My post resolves that."

'Fraid it *doesn't*, Jerry!

Dave's new one does though.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Jerry W. Lewis" wrote in message
...
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

--

Dave Peterson