This video shows you how to use the COUNTIF function in Excel. This functions is very useful when trying to work out how many values fall into a particular category.
The example uses a list or people’s names and then adds an equation to find out how many people have paid their bill and how many people are still to pay.
COUNTIF is very useful if you are looking to make a spreadsheet that works for every user that uses it, however if you are look for simple counting functions then you need to check our pivot tables as these are very fast and require no equations!
We hope you have found this video to be useful – if so then please let us know using the comment box below or the Link or Share buttons above.