SUMIFS over dollar amount threshold
Hi, I currently have a working formula that totals up amount of money for a specific company
=SUMIFS({Cost 2021}, {Subsidiary 2021}, Subsidiary@row)
I now need that formula to be if the cost in column Cost 2021 is greater than 5,000 for that company. I'm struggling with how to get that into the formula. I have gotten all the errors. This is the latest one I have tried and it says invalid operation.
=SUMIFS({Cost 2021}, >"5,000.00", {Subsidiary}, Subsidiary@row)
Any help would be greatly appreciated.
Answers

Provided that your cost column values are numeric and not alpha, this should work.
The SUMIFS syntax is SUMIFS( range criterion_range1 criterion1 [ criterion_range2 criterion2... ])
=SUMIFS({Cost 2021}, {Cost 2021}, > 5000, {Subsidiary}, Subsidiary@row)
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!

I feel so silly THANK YOU SO MUCH! It worked!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!