Function COUNTIF The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.
Functions AND – OR The functions AND or OR are very useful if you have to create a test on more than 1 criteria. Have a look at the examples in this article