• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting outage tickets

Hafeez50

New Member
I have an excel workbook with two worksheets. Sheet one has all the tickets i created for outages. in sheet 2 i want to track the different types of outages that occure in bldg. 1/2 and bldg. 7/8. so i created all the ticktes with outage names such as (bldg. 1/2 - outage name), in sheet 1.


My question is i can't seem to get DCounta to reference sheet 1 + (bldg. 1/2 - Outage name) if it occures on x date?


So i want to set up a count so that if a (bldg. 1/2 - Outage name)ticket is created on a certain date it will creat a count but the ticket will be documented on sheet 1.
 
Assumptions:

Sheet1 has 3 columns. Col A = Bldg Name, Col B = ticket name, Col C = Date.

Sheet2 has the same columns. The desire is to have the count appear in col D of how many lines in Sheet 1 match all 3 critera from col A:C


Formula:

=SUMPRODUCT(--(Sheet1!A$2:A$100=A2),--(Sheet1!B$2:B$100=B2),--(Sheet1!C$2:C$100=C2))
 
Back
Top