SUMIF & CONTAINS
Options
I'm trying to sum column 1 IF, column 2 contains certain text. What would be the formula for that?
Answers

Hi Danielle,
Smartsheet has a page for each Function that is every helpful, take a look at this page for SUMIF:
SUMIF Function  Smartsheet Learning Center
That page shows you that you can first list Column 2 as the range to search for the criterion (the certain text), and then after listing the criterion you can list Column 1 as the actual range to sum.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!