In Google sheets you can use countif to conditionally count cells in a range. For example the following formula will count numbers larger than zero in range A3:A8:
=COUNTIF(A3:A8, ">0")
It can be seen on this sheet, or in the image below:
You can use all the usual comparison operators like =, >, <, >= and <=.
Matching strings
countif can also be used with strings, if we wish to count the number of strings with the content Pending in the range D3:D8 we can use the following formula:
=COUNTIF(D3:D8, "=Pending")
It can be seen on this sheet, or in the image below:
You can use ? as a wildcard character for any character. You can use * to match continuous characters, such as *ing will match both Pending and Processing. ~ can be used to escape ? and * such as ~? and ~*, should they be a part of the string.
Matching multiple criterias
The countif function can only perform matching with a single condition, a simple way to circumvent this is to add multiple countifs together to "match multiple conditions". If we want to count both Pending and Processed from the range H3:H8, we can simply add the two countifs together:
=COUNTIF(H3:H8, "=Pending")+COUNTIF(H3:H8, "=Processed")
It can be seen on this sheet, or in the image below:
That is all
I hope you found this helpful, feel free to leave a comment down below with your thoughts, or if I missed something useful for others!
If you would rather sum the rows, you can check out my post on sumif!