Using Multiple Criteria in Countif Function

How to use multiple criteria in the countif-function in Excel
You cannot use ‘AND’ or ‘OR’ with the countif function as with the ‘IF’ function. That doesn’t work. You have to use the function repeatedly to acheive the goal of using multiple criteria and performing an analysis on your Excel data. View the video to see how this is done!

Further reading:
Excel 2003 COUNTIF Multiple Criteria

Leave a Reply

Your email address will not be published. Required fields are marked *