Formula help required!

[PPBALL]

Hi All,

I work in a call centre environment where we log our calls/emails etc.
When I run the stats, I have a column called 'Contact Type' and a column called 'Caller' (as well as 50 other columns).
I need a formula to give me the total number of tickets where the Caller equals "Third Party" and the Contact Type equals "Inbound Phone". The sticking situation, is that I do not always pull the data in the same column, so I can't base this based on the column letter. I need to be able to index and match based on the column header for these two conditions.

Help please!

Kind Regards,
Priscilla

 

[steve the fish]

You can do that. Which row are the headers in? Also which is the last row and last column of the data?

 

[PPBALL]

Headers are in Row 1 and the last row of the data varies week to week, depending on ticket numbers. On average, we get 1000 every week. The last column of data is 'DA'

 

[steve the fish]

Try this:

=COUNTIFS(INDEX(A:DA,,MATCH("Contact Type",A1:DA1,0)),"Inbound Phone",INDEX(A:DA,,MATCH("Caller",A1:DA1,0)),"Third Party")

 

[steve the fish]

Or use a pivot table...

 

[PPBALL]

That worked perfectly. Thank you so so so so much. I really appreciate it.