# Countif for numbers

• ### Question

• Hello,<o:p></o:p>

I would like to summarize the count of numbers of ID locations from column B (snapshot below).  I would like to use the COUNTIF formula, but coming across a couple of challenges:<o:p></o:p>

1.  Since column B has numbers which in this case, are considered label (ID) and not meant to be added, when I use the Countif formula, I get "You've entered too many arguments for this function" message.<o:p></o:p>

2. There are duplicates Location ID that I would like to summarize. For example, Cateogry X has  Location ID "10" mentioned three times. How can I summarize it into one?<o:p></o:p>

If  COUNTIF is not the appropriate formula, please let me know what works. <o:p></o:p>

Thank you!<o:p></o:p>

Mar

<o:p></o:p>

Tuesday, October 21, 2014 12:48 AM

### All replies

• CountIf on two criteria
The formulas are shown in the picture.
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
(free & commercial excel add-ins & workbooks)

• Edited by Tuesday, November 1, 2016 3:07 AM
Tuesday, October 21, 2014 2:21 AM
• Jim, thank you.

The only thing, my example is a small representation of a larger set of data, that is, I'm dealing with mass number of location IDs.

Mar

Wednesday, October 22, 2014 12:02 AM
• re:  counting

Looks like I answered the wrong question again.
You want a count of unique ID's for each Category.

There is probably a formula to do that, but I don't know what it is right now.
My approach for something like this is to use VBA; it is easier for me to do.
But VBA would require some work.
'---
Jim Cone
Wednesday, October 22, 2014 1:27 AM
• A different approach to counting by category

Hope this picture is self-explanatory.
'---
Jim Cone

Wednesday, October 22, 2014 2:14 AM
• That's ok. I'm avoiding using VBA. I'll try a few more ways. Thank you
Wednesday, October 22, 2014 2:15 AM