Count Items in Column

PROBLEM: How to count items in column (not count number)
SOLUTION: Use addition column and countif function
RESULT:

FOLLOW ME TO STEP-BY-STEP GUIDE

This tutorial will explain to you, how to count items in column.

1. Assume that you have these data.

2. Add one (“1”) to next column. See below !

3. I make up display, to make easier to see.

4. To count how many “phone calls” items, move cursor to cell C12 then type “=COUNTIF($C$3:$D$11,”phone calls”)” (I hide the display for easier, step3)

5. To count how many “website” items, move cursor to cell C13 then type “=COUNTIF($C$3:$D$11,”website”)”

6. To count how many “walk-ins” items, move cursor to cell C14 then type “=COUNTIF($C$3:$D$11,”walk-ins”)”

7. Hide the column D that contain the number one “1” with change the colors to white (don’t delete it)

Done !!! Hope helpfully 🙂

Tags: count