< Go Back

Summary count with COUNTIF

What is COUNTIF function?

COUNTIF function is a statistical function that is used for the counting cells within a specific range on Excel sheet. The function makes it easier to perform summary calculations that produce total counts for various items on the worksheet.

Generic Formula

=COUNTIF(range,criteria)

Example Problem and Solution

Summary count with COUNTIF function is very simple in application. Let’s say that you are managing the production of sneakers and you have some orders. The main spec is color, and you want to keep a record of a number of colors. Let’s you 3 different colors: Black, Blue, and Red this is how you get the breakdown:

Figure 1. Example of the Summary count with COUNTIF

From the screenshot, you can see that we have used COUNTIF to provide a breakdown by color whereas the formula in the G6 is:

=COUNTIF(Colors, F5)

In this case, ‘Colors” is the named range of cells D4:D10. Therefore the actual summary count with the COUNTIF function formula is:

=COUNTIF(D4:D10,"Black")

How COUNTIF Function Formula Works

The COUNTIF Function has two main arguments: A range of the cells to be counted and the criteria to be used. In the above example, we are counting by color. That’s why we have set a small table where we list all colors in Column F. With this table, we can use color names in that column as labels and criteria which goes into COUNTIF as the second argument. That’s simply how you can summary count with COUNTIF function.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar