Could someone help me with this sheet summary formula?

I'm trying to create a formula that adds the amount in the "Amount" column only if the "Revenue Period" column contains "2024". When using this formula I get "0"..

=SUMIFS("Amount", "Revenue Period", "*2024*")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!