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 ) ) )

     

BlueMoose's avatar
BlueMoose
Brass Contributor
Jun 27, 2023
Actually, my formula was fine "=AVERAGEIFS(AM:AM,B:B,AH1)"; but, the problem was that some of them are showing #VALUE. Is there a way to disregard those that are saying #VALUE?

Resources