See g-'s reply.

Nice and simple!

--
Biff
Microsoft Excel MVP


"Peter" wrote in message
...
Hi, it works for me to if I insert it into a blank page and start
fresh. In my spreadsheet, no.

There is not more than one empty cell between any group. So far I
only have three groups. The first one has 14 entries and the next two
each have 27, but it says there are 19 for the last two groups.

I'm assuming it doesn't make any difference how many columns there are
between the data and the count, but in case it did make a difference
I just counted a column that was adjacent.

Very perplexing.

On Fri, 14 Dec 2007 01:09:01 -0500, "T. Valko"
wrote:

Works for me. See this screencap:

http://img205.imageshack.us/img205/3...tconsecpt0.jpg

after changing the references

If it doesn't work tell me where the data is. Is there more than one empty
cell between any group?