Unparseable Error


Hi All,

I am trying to create a sheet summary field formula to sum values in a column, 'Quantity', but only for where the cells in column 'Month' are =3 and the cells in column 'Year' are =2024.

I am receiving an Unparseable error when using the following formula:

=SUMIFS(Quantity:Quantity, Month:Month, 3, Year:Year, 2024))

Any help would be greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!