Thread
:
Trying to get rid of the #DIV/0
View Single Post
#
2
Posted to microsoft.public.excel.misc
UlvaZell
external usenet poster
Posts: 10
Trying to get rid of the #DIV/0
Combine the ISERROR function with an IF statement...
"Matt" wrote:
I have this formula in my cell but Can I get rid of the#DIV/0?
The formula in the cell is =SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)
Reply With Quote
UlvaZell
View Public Profile
Find all posts by UlvaZell