Microsoft Excel Training Home

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

How to use multiple criteria in the countif function in Excel