Mike,

This formula already excludes the blank rows doesn't it? It accommodates the
blank rows, but doesn't count them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
Hi,

I am using the formula below which was posted recently, to count the
number of rows in the defined range excluding duplication which works great.
How would I change this to also exlcude blank rows from the defined range ?.

Thanks for your help

Mike

=SUMPRODUCT((A13:A100<"")/COUNTIF(A13:A100,A13:A100&""))