In this case youd better stick with one of the following alternatives. Excel has many functions where a user needs to specify a single or multiple criteria to get the result. Lets take a look at a few more cool examples.
If we wish to count based on certain criteria then we should use COUNTIF.
For example look at the below data for the sample. This tutorial covers various ways of using a single or multiple criteria in COUNTIF and COUNTIFS function in Excel. Excel COUNTIF formula can be written as follows. The COUNTIF function below uses a named range.
