Forum Discussion
GasDetect
Jan 23, 2025Copper Contributor
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".
- Detlef_LewinSilver Contributor
=AVERAGE(FILTER(range,ISNUMBER(1/(1/range))))
- GasDetectCopper 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_LewinSilver Contributor
My formula has "range". Your formula has "range1" and "range2".