LinkBack URL
About LinkBacks
Can you please explain MAX(1 in this formula? I dont' seem to get it.
=IF(ISERROR(SUM(G33:G36)),0,SUM(G33:G36)/MAX(1,COUNTIF(G33:G36,">0")))
Can you please explain MAX(1 in this formula? I dont' seem to get it.
=IF(ISERROR(SUM(G33:G36)),0,SUM(G33:G36)/MAX(1,COUNTIF(G33:G36,">0")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks