This'll do it... just replace the example range with your range.
=(SUM(B1:B11))/(SUM(COUNTIF(B1:B11,">"""),COUNTIF(B1:B11,">0")))
Posted By: sheffieldcanary, Oct 8, 17:26:53
Reply to Message
Written & Designed By Ben Graves 1999-2025
=(SUM(B1:B11))/(SUM(COUNTIF(B1:B11,">"""),COUNTIF(B1:B11,">0")))
Posted By: sheffieldcanary, Oct 8, 17:26:53
Written & Designed By Ben Graves 1999-2025