Do I use the count or countif formula

Kimberly Poletes

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?

Paul Newcome

You would use a COUNTIFS for this one.

=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")

Paul Newcome

You would use a COUNTIFS for this one.

=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")

Kimberly Poletes

Thank you so much Paul! I was putting the brackets in the wrong place.🙂

Paul Newcome

Happy to help. 👍️