In the last post we looked at using CountA and CountBlank to get information from a list of values. Our list has either a Y or N depending on Whether a person is attending the event.
This post looks at finding out how many Y’s or N’s there are. This can be done using the Countif function.
If the data is in cells B2 to B20 then the formula to find out how many Y’s there are would look like this:
=CountIf (B2:B20, “Y” )
To find out how many N’s there are the calculation would look like this:
=CountIf (B2:B20, “N” )
The next time you need to find out how many, try using one of the Count functions.
Katherine