Formula to sum rows from one sheet based on a date range to a field on another sheet
Hi! As a brief summary, I have created a sheet for our laundry staff to keep track of how many items are being laundered on a daily basis. I have created a separate sheet for monthly totals of each item laundered. I am trying to create a formula that will sum the total number for each laundered item within each month.
For example, if there were 2 bath towels on 7/1...2 bath towels on 7/18... and 3 bath towels on 8/1,...I would need the calculation to show 4 bath towels for July and 3 bath towels for August.
I have attached images to hopefully better explain. "C Unit - Issued Linen" is where I need the totals for each month to go. "C Unit - Archives" is where the data is manually entered.
Answers
-
@nbacguy23 Try something like the formula below. Reference the cell under the description column (description1) or you can do write instead "bath towels" in the Issue Linen sheet. If you're only tracking this year then you don't need the AND(Year, Month) but use instead the Month function.
=sumifs({C Unit-Archives}, @cell =Description1 ,{Date}, AND(YEAR(@cell) = 2023, MONTH(@cell) = 7))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!