Dec 03 2021 01:49 PM
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.
Dec 03 2021 02:29 PM
Solution=AVERAGE(IF(AVERAGE(E4:E1312)>(E4:E1312),IF(AVERAGE(F4:F1312)<(F4:F1312),D4:D1312)))
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.
Dec 03 2021 02:51 PM
Dec 03 2021 02:53 PM
=AVERAGEIFS(D4:D1312,E4:E1312,"<"&AVERAGE(E4:E1312),F4:F1312,">"&AVERAGE(F4:F1312))
Glad it helped. You can as well apply above formula.
Dec 03 2021 02:29 PM
Solution=AVERAGE(IF(AVERAGE(E4:E1312)>(E4:E1312),IF(AVERAGE(F4:F1312)<(F4:F1312),D4:D1312)))
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.