SUMIFS based on another cell

Justin Mauzy

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:

Columns:

Total Issues

Region

Here is the formula:

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

Thank you in advance.

Justin Mauzy

If figured it out. Here is the formula.

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

I was missing some commas.

Thank you.

Justin Mauzy

If figured it out. Here is the formula.

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

I was missing some commas.

Thank you.