Not sure what Formula will work

cane

New member
Joined
May 21, 2013
Messages
2
Reaction score
0
Points
0
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).
Itemhow many ordered
15.53
15.52
10.84
5.162
5.165
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.
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Try the SUMIF function, or , depending on your needs, a Pivot Table ( which could be overkill)
 
Top