Forum Discussion
Solved
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 calcul...
My formula has "range". Your formula has "range1" and "range2".
=AVERAGE(FILTER(range,ISNUMBER(1/(1/range))))
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:
My formula has "range". Your formula has "range1" and "range2".
