Calculating Average Prices

Occasional Contributor

Would like to know how to calculate: The average closing prices on days with below average volume and an above average open price. 


Excel file attached for reference. 

3 Replies
best response confirmed by svaydtla (Occasional Contributor)




Is this what you are looking for? I have to enter formula with ctrl+shift+enter because i don't work with Office365 or 2021.

@Quadruple_Pawn thank you. this is exactly what I needed. It works perfectly. I had the wrong combo originally hence why I needed help.




Glad it helped. You can as well apply above formula.