Excel: COUNTIFS Function

Excel is a great program for doing calculations and I reckon most people use it for that, however, it can do more and one those things is being able to count up instances of how often something occurs in a list. So you might want to know how many times a particular brand was sold that was worth at least a certain value. For this you can use the COUNTIFS function. It can count the number of times it happens based on criteria that can be a number, date or text.

In the video tutorial below you can see how this is done. The examples include a list of software programs and how many Microsoft make to work on a Mac, the second example has a list of foods, their type and calories, in that worksheet we will look at which fruits are 50 calories or more.