SUM entries MTD for each day and each month
I have a sheet with the date on each row starting 07/01/2021 through the end of the fiscal year, 06/30/2022. I need the month to date sum on each row. I sum each date with the date before but I have to manually change the formula at the end of each month. Is there a way to do this automatically so I don't have to restart the formula at the beginning of each month? I feel like it should be a simple fix.
(Here is the formula in the 911 Calls MTD column for each date)
07/01/2021 =SUM([911 Calls Daily]1)
07/02/2021 =SUM([911 Calls MTD]1 + [911 Calls Daily]2)
07/03/2021 =SUM([911 Calls MTD]2 + [911 Calls Daily]3)
Best Answer

I spent the past two days trying to figure it out and I finally got it. I added a helper column to determine the Month and used the following formula:
=SUMIFS([911 Calls Daily]$1:[911 Calls Daily]@row, Month$1:Month@row, Month1)
This formula gives me a running MTD total and automatically resets itself on the first of the month.
Answers

I spent the past two days trying to figure it out and I finally got it. I added a helper column to determine the Month and used the following formula:
=SUMIFS([911 Calls Daily]$1:[911 Calls Daily]@row, Month$1:Month@row, Month1)
This formula gives me a running MTD total and automatically resets itself on the first of the month.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!