SUMIF & VLOOK Adding values

[Gogui]

Hi All,

I'm trying to add quantities values of a table depending of the category reference and costumer (on this case "A"), but I cant figure it out why I have and error on my formula (#Value!).

Category​	Costumer​	Qty​
1​	A​	70,700
5​	B​	-
3​	A​	21,000
3​	C​	12,136
5​	B​	6,560
1​	A​	6,560

=IF(AND($B$2:$B$1267="A"),SUMIF($A$2:$A$1267,VLOOKUP(A1272,$A$2:$C$1267,1,0),$C$2:$C$1267))

Thanks for your help!, I tryed but I'm stock.

 

[arthurbr]

Try a Pivot Table
Are the numbers in col Qty real numbers or text looking like numbers ( data is left-aligned=text ( if no manual alignment))

 

[JoeMo]

Is this what you want?

Book1.xlsm
	A	B	C	D	E	F	G
1	Category	Costumer	Qty		Category	Customer	Qty
2	1	A	70,700		1	A	77260
3	5	B	-		5	B	6560
4	3	A	21,000
5	3	C	12,136
6	5	B	6,560
7	1	A	6,560
Sheet2

Cell Formulas
Range	Formula
G2:G3	G2	=SUMIFS($C$2:$C$7,$A$2:$A$7,$E2,$B$2:$B$7,$F2)

 

[Gogui]

Thank you, it work.
Much appreciated

 

[Gogui]

They are all numbers

 

[JoeMo]

Thank you, it work.
Much appreciated

You are welcome -thanks for the reply.