Mike Slattery
Board Regular
- Joined
- Dec 11, 2004
- Messages
- 101
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
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
