Sum & Percentage Based on Date Entry
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
|