Thanks for letting me know, Sam.
I thought that had to be the reason for it not working for you.

--
Regards
Roger Govier

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:7ff9f922df4c4@uwe...
Hi Roger,

You found my problem, I've got data below the dynamic range. I forgot
about
it. Sorry!

Cheers,
Sam


Roger Govier wrote:
Sam
This has me baffled
I copied the data in exactly as posted, using the "visual aide" column as
well, which was in Column C
If your column C contains 1 header in row 1 and only your numeric data in
the remainder of column C, and if there is no data in column C below your
Dynamic range Data, then COUNT($C:$C) should return the same value as
ROWS(Data)
In all other respects the formulae are identical.

--
Message posted via http://www.officekb.com