Jon Viehe Wrote:
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

Hi Jon

A pivot table would give you the answer you are looking for


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399490