Using SUMIFS formula with CONTAINS or HAS as Criterea

I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and just can't get right. After breaking it apart, I'm finding the CONTAINS part of the formula is what's incorrect.

=SUMIFS({Budget Detail $}, {Budget Detail Acct Code}, CONTAINS("Total", {Budget Detail Acct Code}), {Budget Detail Month}, 10)


Any help is greatly appreciated!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!