Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summing by Attribute (Excel 2000)

    I have a need to create a spreadsheet that has one column with a Code (can vary from RT-01 to RT27)
    and a second column that has the Quantity assigned to that code. There can be multiple entries for
    a specific date and quantity is variable from 1 up. To the right of this, I have a column that shows all
    possible Codes (RT-01 through RT-27) and to the right of that I would like to generate a column that
    shows the number of entries for that code. I could use IFCOUNT to count the number of entries for a
    code, but if the quantity is other than 1 that doesn't work. Any thoughts appreciated.

    See attached file for example of what I need
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summing by Attribute (Excel 2000)

    It looks like you want the frequency of occurrence of a given code in the range $C$3:$C$111...

    In F4 enter & copy down:

    =COUNTIF($C$3:$C$111,E4)

    If you want the total qty per code, use...

    =SUMIF($C$3:$C$111,E4,$B$3:$B$111)

    Aladin
    Microsoft MVP - Excel

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summing by Attribute (Excel 2000)

    The SUMIF formula is exactly what I needed.

    Thanks
    Thomas Cox

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •