Excel summing up values of scattered data [Solved/Closed]

Brian - Oct 16, 2010 at 05:32 AM - Latest reply:  Brian
- Oct 16, 2010 at 12:03 PM
Hello,

I am looking for how to make a cell in excel that tells me how many of a certain item I have. In column b I have values (numerical) of certain items corresponding to column c next to it ie...
B C
1 x
2 y
3 z
5 x
8 y

what I want is a cell that I can have list output like this:

input output (this is where I need help)
x 6
y 10
z 3

tried using search() but that returns an array and tried using row() but first I would need to know the cell location of a found string

THANKS A TON IN ADVANCE



See more 

2 replies

Best answer
aquarelle 7179 Posts Saturday April 7, 2007Registration dateModeratorStatus October 25, 2018 Last seen - Oct 16, 2010 at 07:23 AM
1
Thank you
Hi,

For x use the following formula :

=SUMIF(C1:C5,"x",B1:B5)

and do the same for the others

Regards

Thank you, aquarelle 1

Something to say? Add comment

CCM has helped 1590 users this month

tyvm!! you helped me out a ton