Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.