Learn how to use the CountIf function in this week’s Happy Computers Summer School time saving two minute video!
CountIf allows you to count all the cells that have a given value. For example, if you wanted to count the number of products sold in a certain colour, or the number of sales in a particular city (as in Nicky’s example above). This feature will save you so much time and it’s so easy to use.
Want to learn more?
CountIf is covered in our Microsoft Excel Core Level 2 training course – see upcoming dates below:
- Excel 2013: 20th July, 29th July, 8th August, 22nd August
- Excel 2007 and 2010: 22nd July, 4th August, 25th August
All dates above are based in our offices in Aldgate, London – if you’d like training at your workplace, please contact us for availability and prices. We are currently running an IT Trainer for a Day offer, which gives a day of training any Microsoft Office packages within an IT workshop, one-to-one training, or half a day of IT training, and is free for charities and half price for commercial and public sector organisations.
You can also join our Happy Video Library for just £40 per year to view hundreds of time saving two minute tips – contact us for details of group rates for organisations.
Sign up to our mailing list below for IT training updates and offers to receive our #TipTuesday emails each week throughout July and August!