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!

Screen Shot 2018-08-10 at 3.33.32 PM.png

Find more posts tagged with

Finance

Formulas

Comments

J. Craig Williams

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.

Hong Ly

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…