fireman147
New Member
- Joined
- Jul 10, 2022
- Messages
- 2
- Office Version
- 365
- 2011
- Platform
- Windows
Hello, I have a table and I'd like to sum each row based on the current completed actual month.
EX: It is currently July 10 and the July numbers aren't actually complete. I want the sum for each row to only be up to June even if July - December has a number in it. Then when August rolls around, the sum will include any numbers in the July column.
So: IF TEXT(MONTH(TODAY()-DAY(MONTH(TODAY()),"MMMM") will give me JUNE when its actually JULY, how do I limit the YTD to "6" reflecting only JAN-JUN, and so on for each successive month?
EX: It is currently July 10 and the July numbers aren't actually complete. I want the sum for each row to only be up to June even if July - December has a number in it. Then when August rolls around, the sum will include any numbers in the July column.
So: IF TEXT(MONTH(TODAY()-DAY(MONTH(TODAY()),"MMMM") will give me JUNE when its actually JULY, how do I limit the YTD to "6" reflecting only JAN-JUN, and so on for each successive month?
| F&LS Stats.xlsx | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 2 | Month | |||||||||||||||
| 3 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | |||
| 4 | Fatalities | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 5 | Inspections | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 6 | Plans | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 7 | Revenue | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 8 | Public Education | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 9 | Victim Assistance Runs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 10 | Run Car Responses | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 11 | Contractors Portal | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
| 12 | Portal All Clear Reports | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | ||
Data | ||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| O4:O12 | O4 | =SUM(C4:N4) |
