"COUNTIFS" Function In Excel

This function counts the number of items which match  multiple criterias set by the user.

Syntax

=COUNTIFS(RangeOfThings,Criteria1ToBeMatched,RangeOfThingsToBeCounted,Criteria2ToBeMatched)

The criteria can be typed in any of the  following ways.

To match a piece of text type the text in quotes, such as =COUNTIFS(A1:A5,"Hello",B1:B5,"dp")

To match using operators surround the expression with quotes, such as =COUNTIFS(A1:A5,">50",B1:B5,"43")

To match a specific number type the number, such as =COUNTIFS(A1:A5,100,B1:B5,50)

Example:

Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com