Hey, thanks, that's great. The problem is the rows I am counting contains values not text which is gving me a minus figure due to the sumproduct function. Is there a way around this problem

Thanks in advanc

Mik

----- macropod wrote: ----

Oops

Posted my 'test' version - which used a different range. Yours should be
=SUMPRODUCT((A13:A100<"")/COUNTIF(A13:A100,A13:A100&""))-SUMPRODUCT((A13:A
00=0)/COUNTIF(A13:A100,A13:A100&"")
to elimitate blank rows and rows with 0s, o
=SUMPRODUCT((A13:A100<"")/COUNTIF(A13:A100,A13:A100&""))-SUMPRODUCT((A13:A
00="")/COUNTIF(A13:A100,A13:A100&"")
to eliminate only empty (blank) rows

Cheer


"Mike" wrote in messag
..
Hi
I am using the formula below which was posted recently, to count th
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 hel
Mik
=SUMPRODUCT((A13:A100<"")/COUNTIF(A13:A100,A13:A100&"")


--
Outgoing mail is certified Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/01/200