Yes Roger,

This is really a question of how we read the question and I assumed that 0
did not imply that all numbers were positive in the original data set. And I
did notice the preface but I assumed that a different question was being
asked. As we all know we are up against the wall to guess what questions
often mean. Hopefully users can work out what it is they are asking and
therefore which solutions meet their needs. Nothing wrong with SUM(...)/ if
there are no negative values.

--
Cheers,
Shane Devenshire


"Roger Govier" wrote:

Hi Biff

You did preface your formula, with
Assuming there are no negative numbers in the range
in which case it would be absolutely fine

I think Shane was referring to the fact that the OP said
average the dollars over the months that have a dollar amount greater
than zero?

I think that all other posters have implied from this that there may be
negative numbers, but I agree that may not be what the OP was saying.
I guess using SUMIF(B1:B20,"0") covers both scenarios.

--
Regards

Roger Govier


"T. Valko" wrote in message
...
also Ron's and Nanavati work, but not the other one.

I guess you're referring to mine as the other one? What about it
doesn't work?

Biff

"ShaneDevenshire" wrote in
message ...
Hi,

A few corrections and additional suggestions:

You could use any of the following:


=AVERAGEIF(B1:B12,"0") in 2007
=SUMIF(B1:B12,"0")/COUNTIF(B1:B12,"0") no array

also Ron's and Nanavati work, but not the other one.

--
Cheers,
Shane Devenshire


"T. Valko" wrote:

Assuming there are no negative numbers in the range:

=SUM(B1:B20)/COUNTIF(B1:B20,"0")

Biff

"Chazbri" wrote in message
news:kvGci.165721$_c5.126005@attbi_s22...
Hello,

I have a worksheet that has the months of the year in one column
and a
dollar amount in the next column. At the bottom I have summed the
dollar
amount column.

My question:

What would the formula be if I wanted to average the dollars over
the
months that have a dollar amount greater than zero?

Thank you very much for your help.

Chazbri