Adding based on groups in excel

[vab323]

Hi guys I want to add the sales number if the id is equal

example: I want add 901 and 2994 if id is same in this case id is 40317

539 8th Ave	40317	40317	C	N	Y	901
539 8th Ave	40317	40317	E	N	Y	2994.5

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

 

[jtakw]

Hi,

Does something like this help, you have 2 Columns with the ID in your Table, I used Column B:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	539 8th Ave	40317	40317	C	N	Y	901		ID	TOTAL
2	539 8th Ave	40317	40317	E	N	Y	2994.5		40317	4117.5
3		40315					350		40315	1349
4		40317					222
5		40315					999
Sheet27

Cell Formulas
Range	Formula
J2	=SUMIF(B$1:B$5,I2,G$1:G$5)

Formula copied down.