SUMIFS
I'm trying to make the formula in the first photo refer back to the amounts listed in the second photo and sum the amounts in Contract Terms if the Contract Type is either Flat Rent or Enforcement Only. I feel like I have the formula correct, but it's still showing $0, despite having data in the columns to sum. The sheets are saved, I confirmed that the Contract Terms don't have spaces before/after. I'm not sure what else to check.
Answers

@Erica Shaeffer I think you are trying to use SUMIFS as if it used OR logic. In fact, SUMIFS is strictly AND logic, so all conditions must evaluate to true. Given that none of your rows have contract type of "either Flat Rent or Enforcement Only" the sum will always be zero.
Maybe try:
=SUMIF({Contract terms}, {Contract type}, "Flat Rent") + SUMIF({Contract terms}, {Contract type}, "Enforcement Only")
dm

You can use an OR in there to give it an option of values to choose from for a range.
=SUMIFS({Contract terms}, {Contract type}, OR(@cell = "Flat Rent", @cell = "Enforcement Only"))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!