Forum Discussion

BlueMoose's avatar
BlueMoose
Brass Contributor
Jun 27, 2023
Solved

AVERAGEIF(S) Based on Another Cell

I am looking to find the average of column AM; but, only when column B matches what is in AH1.
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 27, 2023

    BlueMoose 

    As variant  expand to 

    =AVERAGE( IF(col_1=col_2, IF( ISERROR(val), "", val ) ) )

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 27, 2023

BlueMoose 

As variant  expand to 

=AVERAGE( IF(col_1=col_2, IF( ISERROR(val), "", val ) ) )

 

BlueMoose's avatar
BlueMoose
Brass Contributor
Jun 27, 2023
Perfect! That did it exactly. Thanks so much, Sergei!