Thread
:
Hide #div/0 Error When Averaging
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
Posts: n/a
Hide #div/0 Error When Averaging
"Biff" wrote...
Another way:
=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),"")
....
Why should the average of -2, 5 and -3 display as ""?
Never do more work than necessary. Replace SUM with COUNT.
Reply With Quote
Hide #div/0 Error When Averaging