SumIf contains certain text--use FIND?

Sorry, I tried to search the archives but couldn't follow the examples so am hoping someone could help me with this specific scenario. I am trying to put together a budget that is summing up columns that contain certain text. I would like to figure out how to sumif Row 3 all columns containing the term "grant" so that I can get $5000
=SUMIFS([Column4]4:[Column10]4, [Column4]3:[Column10]3, "Grant")
I read that Smartsheet can't search for specific text and someone on another thread suggested some solution using Find. Can someone help understand how I might use "find" in this scenario? Thanks!
Comments
-
This formula will work for both Grant and Contract (5000 / 1500 results)
=SUMIFS($[Column4]$4:$[Column10]$4, $[Column4]$3:$[Column10]$3, FIND([GL Name]@row, @cell) > 0)
I used absolute references so the formula can be copied to the next row
Craig
....
oops. Just noticed you used "Contracts" instead of "Contract". Hopefully you get the idea and can make this work.
-
That worked! Thank you so much!!! I greatly appreciate it. I also didn't now about the @row and @ cell features so look forward to using that in different scenarios too.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.8K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 510 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!