COUNTIF function
 

I have a row of prices, i.e. D14 through P14 are prices for individual weeks,
which I want to find an average of, however depending upon how I filter the
report some weeks have a price of $0.00. Is there a way I can do something
like sum D14 through D27 then divide by a count of those weeks where prices
are greater than 0?

I am thinking that I can do something like this:
=SUM(D14:P14)/COUNTIF(D14:P14,***0)

but I do not know what *** should be?? I am entering this formula in Q14 so
I cannot reference the whole row because of the cyclical reference problem.
I don't know if this is relevant info, just trying to be thorough in my
explanation...Any suggestions?

Thanks for your help.

COUNTIF function
 

Nearly right. Try this:

=SUM(D14:P14)/COUNTIF(D14:P14,"0")

Hope this helps.

Pete

On Aug 15, 8:08*pm, Mike wrote:
I have a row of prices, i.e. D14 through P14 are prices for individual weeks,
which I want to find an average of, however depending upon how I filter the
report some weeks have a price of $0.00. *Is there a way I can do something
like sum D14 through D27 then divide by a count of those weeks where prices
are greater than 0?

I am thinking that I can do something like this:
=SUM(D14:P14)/COUNTIF(D14:P14,***0)

but I do not know what *** should be?? *I am entering this formula in Q14 so
I cannot reference the whole row because of the cyclical reference problem. *
I don't know if this is relevant info, just trying to be thorough in my
explanation...Any suggestions? *

Thanks for your help.