-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how to sumif year/month
- Thread starter go14344
- Start date
excel 2013... real dates..
Upvote
0
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,531
- Office Version
- 365
- Platform
- Windows
On the assumption that you are using tables give this a try:
Left Table is Table1.
Note: You will get a better response and save us a lot of time if you use XL2BB to provide some sample data.
If you need to use an image please include the Row and Column references and also the Table Names if using Tables. This will save you time reworking any formulas we give you.
Left Table is Table1.
Note: You will get a better response and save us a lot of time if you use XL2BB to provide some sample data.
If you need to use an image please include the Row and Column references and also the Table Names if using Tables. This will save you time reworking any formulas we give you.
| 20250124 SumIfs Dates go14344.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Date | Amount Due | Month / Year | 2022 | 2023 | 2024 | 2025 | ||||
| 2 | Sunday, 19 January 2025 | 227,394.08 | January | - | - | - | 250,311.77 | ||||
| 3 | Sunday, 19 January 2025 | 3,339.63 | February | - | - | - | - | ||||
| 4 | Sunday, 19 January 2025 | 19,578.06 | March | - | - | - | - | ||||
| 5 | Sunday, 19 January 2025 | - | April | - | - | - | - | ||||
| 6 | Wednesday, 25 December 2024 | 7,478.75 | May | - | - | - | - | ||||
| 7 | Thursday, 19 December 2024 | 373,274.41 | June | - | - | - | - | ||||
| 8 | Thursday, 19 December 2024 | 3,126.00 | July | - | - | - | - | ||||
| 9 | Thursday, 19 December 2024 | 3,600.28 | August | - | - | - | - | ||||
| 10 | Thursday, 19 December 2024 | - | September | - | - | - | - | ||||
| 11 | Monday, 25 November 2024 | 66,262.36 | October | - | - | - | - | ||||
| 12 | Tuesday, 19 November 2024 | 78,297.46 | November | - | - | 408,235.04 | - | ||||
| 13 | Tuesday, 19 November 2024 | 424.11 | December | - | - | 387,479.44 | - | ||||
| 14 | Tuesday, 19 November 2024 | 260,293.29 | Total | - | - | 795,714.48 | 250,311.77 | ||||
| 15 | Tuesday, 19 November 2024 | 2,957.82 | |||||||||
| 16 | |||||||||||
Data | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F2:I13 | F2 | =SUMIFS(Table1[Amount Due], Table1[Date],">=" & "1-" & [@[Month / Year]] & "-" & F$1, Table1[Date],"<=" & EOMONTH("1-" & [@[Month / Year]] & "-" & F$1,0)) |
| F14 | F14 | =SUBTOTAL(109,[2022]) |
| G14 | G14 | =SUBTOTAL(109,[2023]) |
| H14 | H14 | =SUBTOTAL(109,[2024]) |
| I14 | I14 | =SUBTOTAL(109,[2025]) |
Upvote
0
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,647
- Office Version
- 365
- Platform
- Windows
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Upvote
0
Similar threads
- Solved
