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 achieve the goal of using multiple criteria and performing an analysis on your Excel data. View the video to see how this is done!
Excel 2003 COUNTIF Multiple Criteria