Do I use the count or countif formula

I am trying to create a formula that pulls a count based on data in two columns. Example: I am trying to set up a sheet summary with counts for specific information. Column 1 is a text/number column and is titled "AB Comments" the second column is also a text/number column is titled "status"

is is possible for me to tell it if column 1 (AB comments) reads "expired" and column 2 (Status) reads "keep" that is will count all that meet that criteria throughout the entire sheet in those two columns?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!