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