How get Sum value via "HSN Code" vise ?????? (without pivotable / without filter/ without VBA)

[krunal123]

# How get Sum value via "HSN Code" vise ??????

Advance Condition :
"if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts "


(without pivotable / without filter/ without VBA)

 

[Toadstool]

Hi Krunal123,

I don't see an example of what you are SUMing but SUMIF or SUMIFS may help.

Krunal123-v2.xlsx
	A	B	C	D	E	F	G	H
1							HSN Code	Amount
2	HSN Code	ITME	AMOUNT				80801001	1
3	80801001		9				80809021	2
4	80809021		19				80801001	3
5	80811000		0				80809021	4
6							80801001	5
7							80809021	6
8							80809021	7
9
Sheet1

Cell Formulas
Range	Formula
C3:C5	C3	=SUMIFS(H:H,G:G,A3)

 

[Radoslaw Poprawski]

PQ solution

Book2
	A	B	C	D	E
1	HSN Code	Amount		HSN Code	Sum
2	80801001	316,53		80801001	15 829,65
3	80809021	6948,7		80809021	19 266,00
4	80801001	7002,17		80808000	9 292,78
5	80809021	4226,15
6	80801001	8510,95
7	80809021	8091,15
8	80808000	9292,78
9
10
11
12
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"HSN Code"}, {{"Sum", each List.Sum([Amount]), type number}})
in
    #"Grouped Rows"

no coding neccesery - done from he UI only - group by feature