Forum Discussion

GasDetect's avatar
GasDetect
Copper Contributor
Jan 23, 2025

AVERAGEIF On Multiple Columns, Ignoring 0 and N/A

Hello All, 

I am building a performance review sheet and need to take the average of multiple ratings across cells that are not in the same row or column AND exclude 0 or N/A from the average calculation. Please see the picture for reference. 

 

  • My formula has "range". Your formula has "range1" and "range2".

     

    • GasDetect's avatar
      GasDetect
      Copper Contributor

      Hmmm that didnt seems to work, I just want to be clear. When you have 'range' in the formula I'm inputting the range according to the below pic: 

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor

        My formula has "range". Your formula has "range1" and "range2".

         

Resources