How do I add AND to a COUNTIF (COUNTIFS) formula?


I am tearing my hair out trying to create a formula (for a Sheet summary) that will count the number of rows that has the term HECF in either the Area of focus or Other column. So in the example below, the formula would return "4".

I'd appreciate any help with this. Thanks!!

Is there a way to combine or add COUNTIF formulas, or some other way?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!