Counting

[faberk]

I have a workbook containing 2 sheets. the first sheet (sheet1) contains an
issues log, as follows:

Issue IssueDescrp Category Status
------ -------------- ---------- -------
900 xxxx 1 Open
901 xxxx 9 Closed
902 xxxx 9 Closed
etc
etc

The second sheet (sheet2) I want to summarize each category in column C
(Category) that are indicated as closed in column D (Status). How do I
formulaize this??

Help is greatly appreciated

 

[Toppers]

=SUMPRODUCT(--(Sheet1!C2:C100=<Category>),--(Sheet1!d2100=<Status>))

Replace Category/Status by literals or cells containing value of these

 

[faberk]

Ugh...I negelected to mention that it was the count of each category i want,
where the status is "closed". So sorry :-(