Forum Discussion
sroper2001
Dec 06, 2022Copper Contributor
AVERAGEIF criterion is itself a conditional
I suspect this has been answered before, though I searched and couldn't find it. I want to find the average value of a column of numbers, but ONLY of the number exceeds the value of the cell in an...
- Dec 06, 2022
=AVERAGE(IF(A1:A10>B1:B10,A1:A10))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
PeterBartholomew1
Dec 06, 2022Silver Contributor
Currently, the best formula would be
= AVERAGE(
FILTER(A, A>B)
)
where A and B are names given to your variables.
= AVERAGE(
IF(A>B,A)
)
would also work.
sroper2001
Dec 06, 2022Copper Contributor
Yup, also quite good. Introduced me to the FILTER function! Thanks, Peter!!