Dave R. wrote:
Hmm - this (and the sumproduct one) seem to crap out with any blank cells in
the range. Here's the one that works:
=SUMPRODUCT((D1:D100<"")/COUNTIF(D1:D100,D1:D100&""))
[...]
Here is an explanatory post:
http://www.mrexcel.com/board2/viewtopic.php?t=73502