Hi guys!
I join the discussion a bit late but I had a similar problem and your
formula really helped. Many thanks T . Valko.

I am trying to understand the formula and I'm not sure what the
COUNTIF($A$1:$A1,$A$1:$A1) bit does.
Any chance you can enlight me?

In the sumproduct I understand the formula ($A$1:$A1<""), you count the non
empty cells, but I dont really see whats happens after you divide by the
above.

Thanks