![The COUNTIF function in Microsoft Excel](https://ytimg.googleusercontent.com/vi/-6mkapgjRVw/hqdefault.jpg)
COUNTIF allows you to count all cells that have a given value. For example, if you want to count the number of products sold in a certain color, or the number of sales in a particular city (like in Nicky's example above). This feature will save you a lot of time and it's so easy to use.
You want to know more ?
The COUNTIF function is covered in our Microsoft Excel Core Level 2 training
Choose your version below to see the full course outline and upcoming course dates, or call our office on 020 7375 7300.
Excel 2013 and 2016: bit.ly/HappyExcel2016Level2
Excel 2007 and 2010: bit.ly/HappyExcel2010Level2
You can also join our Happy Video Library for just 40 VAT per year to view hundreds of time-saving two-minute tips – contact us for details of group rates for organizations: https:// videolibrary.happy.co.uk/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments