Sum & Percentage Based on Date Entry

[Karen615]

Using Excel 365

I hope that someone can help me with the below. Please see attached.

When the user adds a date in column L (2024 Inspection), I want to calculate the percentage inspected for each officer (in this case, it would be 50%).
Three sites were inspected out of six (cell C8).

Then I need the overall percentage (in this case, it would be 12%). Three sites were inspected out of 25 (cell C31).

Also, based on the same date entry in column L, I need to sum the total Principle Balance for each officer. In this case, it would be $3,908,828.93. (Cell range E2:E4). Then the overall total among all the officers. Since I just have the three entries, it would still be, $3,908,828.93.

Do you have a recommendation where to put all these results?



I would GREATLY appreciate any help someone could offer.

Thank you in advance,
Karen