Forum Discussion

sroper2001's avatar
sroper2001
Copper Contributor
Dec 06, 2022

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...
  • OliverScheurich's avatar
    Dec 06, 2022

    sroper2001 

    =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.

     

Resources