Thread
:
Averageif Error
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Curtis
external usenet poster
Posts: 181
Averageif Error
I am using the formula
averageif($G219:$N219,"<0") in my workbook however if one of the cells
contains "0" it returns the error #DIV/0!
Why and how can I get rid of it
Thanks
Reply With Quote
Curtis
View Public Profile
Find all posts by Curtis