Good morning all.

I can't seem how to work this out. In my column R, I have 102 pieces of different data. I want a count of how many times each of those pieces of data are in in column C. Column C has like 3000 pieces of data.

To be clear, it's possible that the majority of the pieces of column R will have a total count of 0. Some may have 1, some may have 2, etc.

Can't seem to nail down the right formula!

EBS Computer Services is an IT service provider.

## 6 Replies

EBS Computer Services is an IT service provider.

Seems like it's pretty straightforward:

```
=COUNTIF([range], [value])
```

Plug in your range (range would be C:C for the entire column) and the value (which you can just slap R1, R16, whatever in) and it should return the number of exact matches.

If you have partial matches, that's a bit different.

That would work, but why not just use C:C to grab the entire column and not have to worry about how far the data goes or making it static? Not trying to make a point here, just wondering.I would recommend creating an additional Column to the side of R, Column S will have the totals of each data so the formula will be:

=COUNTIF($C$2:$C$300,R2)

Where R2 is the Piece of data compared to be counted towards the Column S

dbeato