jski21
Board Regular
- Joined
- Jan 2, 2019
- Messages
- 155
- Office Version
- 2016
- Platform
- Windows
Good day Mr. Excel Team,
Is there a way--by formula--to find the last entry in a column (0 or otherwise) and return the sum of all the entries prior to that last entry? Example:
The last entry here is Dec23. Seeking a way to return the sum of all the values prior to Dec23 which would be 1,379,859.39.
As always, thanks for your consideration and help.
jski
Is there a way--by formula--to find the last entry in a column (0 or otherwise) and return the sum of all the entries prior to that last entry? Example:
| Prjct Clean Disbursements PY49 2023-2024.xlsx | |||||
|---|---|---|---|---|---|
| F | G | H | |||
| 1 | Period | Personnel | # of Services | ||
| 2 | Jun-23 | - | 2,793 | ||
| 3 | Jul-23 | - | 9,046 | ||
| 4 | Aug-23 | 234,978.13 | 7,172 | ||
| 5 | Sep-23 | - | 7,366 | ||
| 6 | Oct-23 | 1,144,881.26 | 8,892 | ||
| 7 | Nov-23 | - | - | ||
| 8 | Dec-23 | 65,118.74 | 12,907 | ||
| 9 | Jan-24 | ||||
| 10 | Feb-24 | ||||
| 11 | Mar-24 | ||||
| 12 | Apr-24 | ||||
| 13 | May-24 | ||||
| 14 | FINAL | ||||
| 15 | Total | $1,444,978.13 | 48,176 | ||
Personnel (Labor) | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F3:F12 | F3 | =DATE(YEAR(F2),MONTH(F2)+1,1) |
| F13 | F13 | =EOMONTH(F12,1) |
| G15:H15 | G15 | =SUM(G2:G13) |
The last entry here is Dec23. Seeking a way to return the sum of all the values prior to Dec23 which would be 1,379,859.39.
As always, thanks for your consideration and help.
jski
