I worked out the formula below to count if frequency. However, now I need to work it out for 2 criterias.
Count if I:I = A2 and if R:R = Closed
What I have so far is this:
{=COUNT(IF(FREQUENCY(IF(ticketInformation!I:I=A2,ticketInformation!B:B),ticketInformation!B:B),1))}
Count if I:I = A2 and if R:R = Closed
What I have so far is this:
{=COUNT(IF(FREQUENCY(IF(ticketInformation!I:I=A2,ticketInformation!B:B),ticketInformation!B:B),1))}