I'm simplifying this a little, but essentially I have a spreadsheet with application dates in column A, office codes in column B, customer PINs in column C, approval dates in column D, denial dates in column E, and # of prev apps in column F.

Customers may apply for a process and be approved the first time, but if not, they may continue to apply as many times as they wish, so I can have multiple rows of data for the same customer.

The # of apps cell in a corresponding record is left blank for the first app, but each subsequent app, if any, are numbered: 2, 3, 4, etc.

I've been able to track the total number of applications coming out of each office, but I'm seeing a trend that some offices have much higher rates of first time approvals with their customers than others and believe these offices are doing a better job of assisting their customers in meeting the requirements. I want to be able to count the number of customers each office is seeing and what percentage of those were approved the first time they applied.

I've been trying different CountIf and SumProduct formulas, but just haven't been able to figure this out. My brain is fried! Can you help? THANKS!