Formula to sum rows from one sheet based on a date range to a field on another sheet

nbacguy23

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.

Razetto

@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))

https://help.smartsheet.com/function/sumifs