Results 1 to 2 of 2

Thread: Not sure what Formula will work

  1. #1

    Not sure what Formula will work



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a list of items: "15.5", "10.8", 5.16" that are listed in a single column. Then in the next column I capture how many times each item is ordered. What I need is a formula that will give me a total count of each item. Both columns are dynamic and the items can be any of the three listed above, the "how many ordered" column can be any number, and in any order(not sequential).
    Item how many ordered
    15.5 3
    15.5 2
    10.8 4
    5.16 2
    5.16 5
    So my answers would be.
    15.5 = 5
    10.8 = 4
    5.16 = 7
    So I need a forumla that will look through column A and find every instance of "15.5", then look through column B and add up the total numbers associated with "15.5" in column A. Answer would be 5.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Try the SUMIF function, or , depending on your needs, a Pivot Table ( which could be overkill)

Posting Permissions

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