Date Formula
I looking for help on a formula that will SUM the column by month. So when I go into a new month, it will sum only the month we are in since the column represents all months of the year. I have a supporting value and formula sheet that host these values and are linked to my dashboard. I currently have to edit reference the fields to select the cells in the present month. I have attached an image of the columns in question. Any help in this matter will greatly be appreciated.
Comments
-
Hi there,
You can accomplish this using a SUMIFS statement. Try this formula
=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = MONTH(TODAY()), [Date Approved]:[Date Approved], YEAR(@cell) = YEAR(TODAY()))
It will look at the month and year of today and provide you with the sum value of all of the fees of the current month/day.
If you want to manually input the year and Month you can use this one... This would be good for summary data for each month.
=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = 3, [Date Approved]:[Date Approved], YEAR(@cell) = 2018)
Replace the 3 with the month you want and the year with the year you want.
Hope that helps!
-
Thank you Mike, the formula worked perfect for my situation.
-
Awesome. Glad I could be of help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!