How To Sum Qty product Wise

[krunal123]

# How To Sum Qty product Wise ????

-> Sheet 1 and Sheet 2 Sum Qty via Product based to Sheet 3, but Condition is Both List not same in a Serial , How to find Total with Product Based ?????????????????????????????????????????????????????

 

[maabadi]

Try this:

=VLOOKUP(A3,Sheet1!$A$3:$B$6,2,FALSE)+VLOOKUP(A3,Sheet2!$A$3:$B$6,2,FALSE)

Change Range to Your Range at sheet1 & Your Range at sheet2.

 

[mehidy1437]

Also see this Sumif across sheets

 

[alansidman]

You could append one sheet to the other in power Query and then perform a Group By and Sum the Group.

 

[krunal123]

# How to sum Qty to 10 sheet or more Sheet, How to possible with Name ??????????

As per Above Style Query........

 

[alansidman]

Please provide some sample worksheets in XL2BB so that we can demonstrate with actual data. We cannot manipulate data in pictures.

 

[sandy666]

table1			table2			Result
Product	Qty		Product	Qty		Product	Qty
BEER	200		WINE	100		BEER	250
WINE	100		BEER	50		WINE	200
VODKA	50		BRANDY	150		VODKA	550
BRANDY	300		VODKA	500		BRANDY	450

let
    Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Append = Table.Combine({Source1, Source2}),
    Group = Table.Group(Append, {"Product"}, {{"Qty", each List.Sum([Qty]), type number}})
in
    Group

You can load result table wherever you want