MS Excel count distinct values in a range July 10, 2015 Posted by silver =SUMPRODUCT((Q85:Q1095<>"")/COUNTIF(Q85:Q1095,Q85:Q1095&"")) Updated: December 18, 2017 at 8:19 am ◀ DB2 MS Excel VBA for when you are getting spurious & seemingly random ‘Code has been interrupted’ ▶