I have a spreadsheet that has a list of all errors made by our agents. Column B has an agent name. In column I, I need a total number of times the name appears in the sheet (this is the number of errors for that person). We are not removing duplicates because each row is a unique error. I just need to be able to look at each line and see the total number of errors that person made.

The data is dynamic and will change in length. I'm having difficulty incorporating the last row into the formula, but I need it to read what the last row is and stop calculating at that point. There is existing code prior to this point and I have already declared LR as last row and LC as last column in the prior code. I've tried setting a range and using that within the formula, but obviously i'm doing something wrong LOL

Assistance is appreciated; I'm still learning :-)