On Thu, 13 Oct 2005 08:37:06 -0700, "Alok"
wrote:

Use Pivot table on the data. Take the Credit Union Contract number on the row
and the count of the same field into the data area.

Good point and far simpler than Subtotal or Countif.

Rgds


Alok

"Ellen" wrote:

I have a spread sheet with about 20k users in it sorted by contract # of CU
they belong to. Is there a way I can use the sorted users to provide a total
number of users for each credit union?

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________