Counting
 

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 :-)

Counting
 

=SUMPRODUCT(--(Sheet1!C2:C100=<Category),--(Sheet1!d2:D100=<Status))

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

"faberk" wrote:

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 :-)

Counting
 

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


"Toppers" wrote:

=SUMPRODUCT(--(Sheet1!C2:C100=<Category),--(Sheet1!d2:D100=<Status))

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

"faberk" wrote:

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 :-)