I am actually pretty handy with Excel, but ran into something today that I've wanted to "automate" via a formula for some time.
Here is what I've got.
I work in IT support and have a report of all of my technicians' tickets. I am trying to report back on how many of their tickets were "late" per technician.
Just for this situation, lets say that all of the tickets are sorted alphabetically by technician, and that there are 3 columns (there are more, but this will be all that matters for the formula).
Column A is ticket number
Column B is technician's name
Column C is either blank or it has a note about a ticket being late.
For getting total ticket counts I've been using the COUNTIF function to count how many times a technician's name shows up on the report. But for this, I want a count of how many times that technician has something entered in Column C.
Only late tickets have an entry in Column C, otherwise it is blank like I said.
I am sure that this will be one of those "oh, duh" moments, but I'm not getting it yet.
Thanks everyone.
