SUMIFS based on another cell

I want to add cells (SUM) if there is text in another cell. So, basically I need to add the sum form the Total Issue column if there is any text in the Region column. Here is the example:


Total Issues


Here is the formula:

=SUMIFS([Total Issues]:[Total Issues]) AND( [Region]:[Region], ISTEXT(@cell))

Thank you in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!