I think this brings up a point of logic.

If zero is not to be used, how do we go from positive to negative without
there being the possibility of the existence of zero?

How do you set the calculations to *bypass that exact* zero transition
point?

Therefore, I assumed:
No Zero
No Negatives

But of course ... the OP is the final word!

--

Regards,

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

"Teethless mama" wrote in message
...
Try like this:

=SUM(A1:A100)/SUM(COUNTIF(A1:A100,{"0","<0"}))


"RagDyer" wrote:

Try this"

=Sum(A1:A100)/Countif(A1:A100,"<0")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"markmcd" wrote in message
...
Could someone please advise me a nice simple formula for giving an
average
for non zero entries. The average function in Excel provides an average
of
a
list of numbers including numbers that are zero. I need the average of
just a
series of numbers where zeros are not considered in the result.