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
 Smartsheet Customer Resources
 62.2K Get Help
 361 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!