Identify the type of cell - $C$1 + $D$1.
Answers
Answer:
The COUNTIF/S functions work ALMOST in the same way as the SUMIF/S functions only they’re slightly simpler. So if you haven’t mastered SUMIF/S yet be sure to check out our SUMIF/S tutorial too.
COUNTIF extends the capabilities of the basic COUNT function by allowing you to tell Excel to only COUNT items that meet a certain criteria. New in Excel 2007 is the COUNTIFS function, which allows you to stipulate multiple criteria, hence the plural.
Enough explanation, let’s dive into an example as it’s easier to visualise.
COUNTIF Function
The function wizard in Excel describes COUNTIF as:
=COUNTIF(range,criteria)
Looks fairly simple and it is. Let’s translate it into English now by applying it to an example. Say we wanted to count the number of times Dave appeared in column C of the table below.
COUNTIF Formula Explained
Translated our formula would read like this:
=COUNTIF(count the number of cells in column C, that contain 'Dave')
We could even create a table under the data to count the occurrences of each builder: