lookup then count values

[Scarybuh]

Good day,

I have an inventory in excel, that for each line in this sheet, it searches in another sheet for it and counts one
=COUNTIF(range, criterion)
=COUNTIF(Saidas!$A$2:$A$33,$A164)
So for example, I got the same code bars in diferent lines in the sheet Saidas the result here would be 3 for the barcode 111, and 1 for the barcodes 222 and 555.
111
222
111
555
111

What I want to improve now is getting the value next to it in another column and sum them,
111 5
222 3
111 10
555 8
111 5

I need a formula that searches for the 111 values and sums the values next to them, so for the 111 I would have 5+10+5 = 20
for the 222, I would have 3, and for 555 I would get the 8.
I tried the countifs and lookup but they don't do exactly what I'm looking for, the lookup would stop on the first result and throw me just the value 5.
Help would be appreciated, thanks.

 

[Toadstool]

Hi Scarybuh,

If you just want totals next to each row then you can use SUMIF or SUMIFS.

If you want a list of distinct Numbers with their totals then create the distinct list (column E) then do the SUMIF (column F).

Book1
	A	B	C	D	E	F
1	Number	Value	Sum		Distinct	Sum 2
2	111	5	20		111	20
3	222	3	3		222	3
4	111	10	20		555	8
5	555	8	8
6	111	5	20
Sheet1

Cell Formulas
Range	Formula
F2:F4	F2	=SUMIF($A$2:$A$12,$E$2:$E$12,$B$2:$B$12)
C2:C6	C2	=SUMIF($A$2:$A$12,A2,$B$2:$B$12)
E2:E6	E2	=IFERROR(INDEX($A$2:$A$12, MATCH(0, INDEX(COUNTIF($E$1:E1, $A$2:$A$12),0,0), 0))&"", "")

 

[Scarybuh]

Thank you!

It's working now, cheers.