Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Function | Excel Discussion (Misc queries) | |||
countif function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions |