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

- - 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 

1 reply

Best answer
Posts
7170
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 24, 2019
666
1
Thank you
Hi,

For x use the following formula :

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

and do the same for the others

Regards

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 4461 users have said thank you to us this month

tyvm!! you helped me out a ton