Thread: [Solved] Based on Date Entry, Calculate SUM & Percentage
View Single Post
 
Old 02-04-2024, 02:36 PM
Karen615 Karen615 is offline Windows 11 Office 2021
Competent Performer
  
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default Based on Date Entry, Calculate SUM & Percentage
Using Excel 365

I desperately need help. Please see attached.

Each time a site is inspected, a date is entered in column L. I need a formula (in cell R2) that sums the Principle dollar amount of sites inspected. Please see cell R2 for the actual result it should be.

Then I need the overall percentage to calculate as sites are inspected. Please see cell R3 for the actual result it should be. Five sites were inspected out of the grand total of 25 (cell C31).

I would GREATLY appreciate ANY help someone could offer.

Thank you in advance,
Karen
Attached Files
File Type: xlsx Plan2.xlsx (22.6 KB, 12 views)
Reply With Quote