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