none
Countif for numbers RRS feed

  • 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 James Cone 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