Count IFS

I am trying to "countif" the Last Name and the First name in Summary. I figured out how to count the last name =COUNTIF([Last Name]:[Last Name], "Roman") but what do I have to do to capture the first name if it is in a different cell? =COUNTIFS([Last Name]:[First Name], "Roman" "Kate"). I can't figure out how to capture the first name.

Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!