Forum Discussion
Solved
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...
=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.
=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.
Yes! Perfect!! A million thanks! I assume will also work with SUMIF when I want to sum those numbers instead of averaging them. You've made my day!