


Please type this formula into the desired cell: If there are multiple criteria in multiple columns, such as following screenshot shown, and I want to get the number of KTE whose order is greater than 300 and the name is Ruby.

Note: This feature also can help you to select and count the cells between two specific numbers or dates as the following screenshots shown:ĭownload and free trial Kutools for Excel Now!Ĭountif with multiple criteria in multiple columns In the Select Specific Cells dialog box, please set the operations as you need, and then click OK, the specific cells have been selected and the number of the cells are shown in the prompt box as below screenshots shown: Select the list of cells that you want to count cells based on criteria, and then click Kutools > Select > Select Specific Cells, see screenshot:Ģ. Tips: To apply this Select Specific Cells feature, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Īfter installing Kutools for Excel, please do as this:ġ.
