I have the following formula:
=SUM(F3)/COUNTIF(G3:CS3,">0")
If answer is nothing it yields:
#DIV/0!
How can I get nothing to yield as the number zero?
I have the following formula:
=SUM(F3)/COUNTIF(G3:CS3,">0")
If answer is nothing it yields:
#DIV/0!
How can I get nothing to yield as the number zero?
=iferror(F3 / COUNTIF(G3:CS3, ">0"), 0)
Entia non sunt multiplicanda sine necessitate
Perfect thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks