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.
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.