SUMIFS formula

peter65516

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

Kelly Moore

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

peter65516

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!

Kelly Moore

I'm glad it helped! Thanks for coming to the community

Kelly