Counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :-)
 
=SUMPRODUCT(--(Sheet1!C2:C100=<Category>),--(Sheet1!d2:D100=<Status>))

Replace Category/Status by literals or cells containing value of these
 
=SUMPRODUCT(--(Sheet1!C2:C100=<Category>),--(Sheet1!d2:D100=<Status>))

Replace Category/Status by literals or cells containing value of these
 
Ugh...I negelected to mention that it was the count of each category i want,
where the status is "closed". So sorry :-(
 
Ugh...I negelected to mention that it was the count of each category i want,
where the status is "closed". So sorry :-(
 
Back
Top