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
-
You would use a COUNTIFS for this one.
=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")
Answers
-
You would use a COUNTIFS for this one.
=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")
-
Thank you so much Paul! I was putting the brackets in the wrong place.🙂
Help Article Resources
Categories
Check out the Formula Handbook template!
