Assume Sheet1 contains your original data in cells A1:B9, including the
headers "Dept" and "Units" (

Sheet2 contains your summary & Criteria

Criteria for dept 331 is specified as follows in D1:D2. Note "Dept"
must exactly match the header in the table, including any spaces; it
helps to copy/paste this to the criteria range.

Dept
331

The summary for Dept 331 contains the formula

=DCOUNT(Sheet2!$A$1:$B$9,2,D3:D4)

Same for the other depts

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512842