Formula Query
Created a formula for counting numbers in a cell if a specific contact is listed in another column. Getting errors
=SUMIF({Tracker Range 1}, >0, [{Tracker Range 2}, FIND)"Terri", @cell)>0])
Best Answer

Hey
Try this as one approach.
=SUMIFS({Tracker Range 1}, {Tracker Range 1}, >0, {Tracker Range 2}, FIND("Terri", @cell) = true)
In your original formula you had a couple of opportunities. One, SUMIF can only be used with one criteria. You have two. For that reason, anytime I need a SUMIF/SUMIFS function, I prefer to use the SUMIFS (plural) function which always works even if only one criteria is needed. You also had some syntax errors and bracketing errors.
Answers

Hey
Try this as one approach.
=SUMIFS({Tracker Range 1}, {Tracker Range 1}, >0, {Tracker Range 2}, FIND("Terri", @cell) = true)
In your original formula you had a couple of opportunities. One, SUMIF can only be used with one criteria. You have two. For that reason, anytime I need a SUMIF/SUMIFS function, I prefer to use the SUMIFS (plural) function which always works even if only one criteria is needed. You also had some syntax errors and bracketing errors.

Thanks so much!!!! This community is so very help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 283 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!