Formula to total cells with same code in column next to them

[sobrien1234]

In column A I have a list of unique identifying numbers (codes) of which there may be many of the same code spread intermittently down the column. In column B I have a list of numbers that these codes represent. I want a formula that will add up all the numbers in column B that have the same unique identifier in column A. I tried =sum(if(a2:a1000=a2,b2:b1000)) but it doesn't work? I also highlighted it and press control/shift/enter and it turned into a #N/A

Any suggestions?

Thanks

 

[Kamolga]

=sumif(a:a,a2,b:b)

Note: Your formula would work if you pressed CTRL+SHIFT +Enter after you typed it to get brackets around it (Array formula) but I would recommand sumif function instead

 

[RasGhul]

Maybe try;

Book1
	A	B	C	D
1	unique1	100	UIN	Result
2		101	unique1	995
3		102
4		103
5	unique1	104
6		105
7	unique1	106
8		107
9	unique1	108
10		109
11		110
12	unique1	111
13		112
14		113
15		114
16	unique1	115
17	unique1	116
18	unique1	117
19	unique1	118
Sheet1

Cell Formulas
Range	Formula
D2	=SUMPRODUCT(($A$1:$A$19=$C$2)*$B$1:$B$19)

 

[Aladin Akyurek]

@ sobrien1234

Do you have formulas in column A and/or column B which could return #N/A?

 

[sobrien1234]

Maybe try;

	A	B	C	D
1	unique1	100	UIN	Result
2		101	unique1	995
3		102
4		103
5	unique1	104
6		105
7	unique1	106
8		107
9	unique1	108
10		109
11		110
12	unique1	111
13		112
14		113
15		114
16	unique1	115
17	unique1	116
18	unique1	117
19	unique1	118

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =SUMPRODUCT(($A$1:$A$19=$C$2)*$B$1:$B$19) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks

 

[sobrien1234]

Perfect - you were right on both - had an error in column A