Interesting, maybe unanswerable CountIf Question?

[Mike Slattery]

I have two columns:

The first is the volume for a stock and the second is that stocks price at that volume when it touched a support or resistance level.

Volume Turning Point Price
9795000 520.03
9826700 0
12596300 0
22707400 0
19658600 0
12064000 0
13741600 531.91
11204400 0
19073700 0
14218100 0
10376500 0
9056900 504.5
8967900 0
11431200 0
9353500 496.04

I need a solution for producing the Average Volume between the stock price numbers that are not zeros. As you can see the range is variable, so I have not been able to figure out how to utilize the most obvious solutions, i.e., CountIf or SumIf as I can not enter a range of cells?


Grateful for any ideas?

Thanks Michael

 

[Pup Denab]

Hi Mike
No problem, Glad I could help. and thank you for the feedback,
Regards
Pup