Separate columns?

If so

=COUNTIF(B:B,"dept1")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jon Viehe" wrote in message
...
I have a list of 150 assets which are assigned to 20 or so depts. How can
I
count the number of assets per dept. In essence counting the number of
times
different values reoccur? For example

Asset1 - dept1
asset2 - dept 1
asset3-dept2
asset4-dept2
asset5-dept3

dept1 has 2 assets
dept2 has 2 assets
dept3 has 1 asset

Id like to avoid doing a COUNTIF and having to type each dept name