SUMIFS formula
Hi,
Can someone help me with a formula to track how many packs have been taken/used each month of each year? I have MONTH and YEAR columns from a date entered.
So far no luck with =SUMIFS(Number taken:Number taken, MONTH "1", YEAR "2022")
Answers

Hey @peter65516
The syntax needs some adjusting. The syntax is SUMIFS(range to be summed, range1, criteria1, criteria2, etc). The formula is missing the commas in between ranges and criteria and the criteria ranges need to identified as the entire column  don't forget column names that include spaces, numbers or special characters require square brackets. Also, Numbers should not be enclosed in quotes. This confuses smartsheet as to whether the enclosed numbers should behave as text or as numbers. It is seldom any number should ever be enclosed.
=SUMIFS([Number taken]:[Number taken], Month:Month, 1, Year:Year, 2022)
Does this work for you?
Kelly

Thank you Kelly, I have such trouble with formulas but I learnt some very handy things from your answer and you solved my immediate problem. Thanks again!

I'm glad it helped! Thanks for coming to the community
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!