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.

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?