=COUNTIF (range to be analysed, criteria)

The COUNTIF function is very similar to the SUMIF function in that it analyses a specified range against set criteria and returns the number of occurrences of this criteria.


In the above examples the function is used to count items provided by “Invo8”, as you can see there are 6 occurrences in the left hand side table.


A more powerful application is to COUNTIF items over a certain value.


The above function states that any item over £200 will be counted.