#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum & Percentage Based on Date Entry | Karen615 | Excel | 5 | 02-10-2024 08:44 PM |
Calculate week in Word document based on date entered into same document | ArviLaanemets | Word VBA | 4 | 11-18-2019 12:25 AM |
Text Form Field -Calculate Percentage | Perk | Word | 5 | 04-18-2016 09:05 PM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Formula to auto calculate Day of the week based on Date | prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |