Excel summing up values of scattered data

Solved/Closed
Brian - Oct 16, 2010 at 05:32 AM
 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



1 reply

aquarelle Posts 7118 Registration date Saturday April 7, 2007 Status Moderator Last seen July 29, 2022 491
Oct 16, 2010 at 07:23 AM
Hi,

For x use the following formula :

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

and do the same for the others

Regards
1
tyvm!! you helped me out a ton
0