Summing totals on different sheet if criteria is met

[JakariKryze]

I have data in one sheet that i am manipulating and i need to sum all the totals of items of the same type together on a summary page. i am still new to VBA and so i dont have a code to start out with.
This is the Blackboard Sheet and the one below it is the Summary sheet. I need to sum all the totals of the same type and have it appear in the summary page in the second column. thanks for your help.

Retail Tran Date	Product Department Name	Sum of Product Net Sales Amt	Sum of Product Tax Amount	Sales Total
12/8/2021 0:00​	ACF - Bulk - Tax	$14.25​	$1.14​	$15.39​
12/3/2021 0:00​	ACF - Drinks - Tax	$18.00​	$1.27​	$19.27​
12/8/2021 0:00​	ACF - Drinks - Tax	$13.50​	$1.04​	$14.54​
12/7/2021 0:00​	ACF - Drinks - Tax	$8.10​	$0.57​	$8.67​
12/2/2021 0:00​	ACF - Drinks - Tax	$11.70​	$0.90​	$12.60​
12/10/2021 0:00​	ACF - Drinks - Tax	$44.70​	$3.27​	$47.97​
12/6/2021 0:00​	ACF - Drinks - Tax	$31.50​	$2.36​	$33.86​
12/9/2021 0:00​	ACF - Drinks - Tax	$60.30​	$4.27​	$64.57​
12/2/2021 0:00​	ACF - Gift Boxes - No Tax	$38.85​	$0.00​	$38.85​
12/1/2021 0:00​	ACF - Gift Boxes - No Tax	$50.00​	$0.00​	$50.00​
12/6/2021 0:00​	ACF - Gift Boxes - Tax	$59.95​	$4.20​	$64.15​
12/8/2021 0:00​	ACF - Gift Boxes - Tax	$39.90​	$0.00​	$39.90​
12/3/2021 0:00​	ACF - Gift Boxes - Tax	$19.95​	$1.40​	$21.35​
12/10/2021 0:00​	ACF - Gift Boxes - Tax	$99.95​	$7.00​	$106.95​
12/9/2021 0:00​	ACF - Gift Boxes - Tax	$29.95​	$2.10​	$32.05​
12/8/2021 0:00​	ACF - Misc - No Tax	$461.54​	$0.00​	$461.54​
12/1/2021 0:00​	ACF - Misc - No Tax	$248.65​	$0.00​	$248.65​
12/2/2021 0:00​	ACF - Misc - No Tax	$150.00​	$0.00​	$150.00​
12/9/2021 0:00​	ACF - Misc - No Tax	$825.72​	$0.00​	$825.72​
12/7/2021 0:00​	ACF - Misc - No Tax	$2,597.60​	$0.00​	$2,597.60​
12/10/2021 0:00​	ACF - Misc - No Tax	$192.27​	$0.00​	$192.27​
12/3/2021 0:00​	ACF - Misc - No Tax	$127.25​	$0.00​	$127.25​
12/2/2021 0:00​	ACF - Misc - Tax	$2,886.36​	$202.06​	$3,088.42​
12/10/2021 0:00​	ACF - Misc - Tax	$171.19​	$11.96​	$183.15​
12/7/2021 0:00​	ACF - Misc - Tax	$42.16​	$2.38​	$44.54​
12/9/2021 0:00​	ACF - Misc - Tax	$255.02​	$17.91​	$272.93​
12/3/2021 0:00​	ACF - Misc - Tax	$226.78​	$16.36​	$243.14​
12/6/2021 0:00​	ACF - Misc - Tax	$137.80​	$10.21​	$148.01​
12/8/2021 0:00​	ACF - Misc - Tax	$149.83​	$10.91​	$160.74​
12/1/2021 0:00​	ACF - Misc - Tax	$272.35​	$19.84​	$292.19​
12/9/2021 0:00​	ACF - Mixes	$59.85​	$4.19​	$64.04​
12/1/2021 0:00​	ACF - Mixes	$28.80​	$1.40​	$30.20​
12/6/2021 0:00​	ACF - Mixes	$104.58​	$7.31​	$111.89​
12/8/2021 0:00​	ACF - Mixes	$19.95​	$1.39​	$21.34​
12/7/2021 0:00​	ACF - Mixes	$5.90​	$0.41​	$6.31​
12/10/2021 0:00​	ACF - Mixes	$73.70​	$4.75​	$78.45​
12/3/2021 0:00​	ACF - Mixes	$69.16​	$4.84​	$74.00​
12/9/2021 0:00​	ACF - Mixes - NT	$78.95​	$0.00​	$78.95​
12/1/2021 0:00​	ACF - Swag - Tax	$23.85​	$0.00​	$23.85​
12/7/2021 0:00​	ACF - Swag - Tax	$7.99​	$0.56​	$8.55​
12/6/2021 0:00​	ACF - Swag - Tax	$6.36​	$0.51​	$6.87​
12/3/2021 0:00​	ACF - Swag - Tax	$7.95​	$0.64​	$8.59​
12/2/2021 0:00​	ACF - Swag - Tax	$9.99​	$0.70​	$10.69​
12/10/2021 0:00​	ACF - Thistle & Rose - NT	$17.56​	$0.00​	$17.56​
12/10/2021 0:00​	ACF - Thistle & Rose - Ta	$516.48​	$33.74​	$550.22​
12/2/2021 0:00​	ACF - Thistle & Rose - Ta	$56.60​	$2.96​	$59.56​
12/6/2021 0:00​	ACF - Thistle & Rose - Ta	$168.51​	$6.70​	$175.21​
12/7/2021 0:00​	ACF - Thistle & Rose - Ta	$42.11​	$1.20​	$43.31​
12/9/2021 0:00​	ACF - Thistle & Rose - Ta	$162.65​	$10.34​	$172.99​
12/3/2021 0:00​	ACF - Thistle & Rose - Ta	$143.00​	$8.22​	$151.22​
12/1/2021 0:00​	ACF - Thistle & Rose - Ta	$29.75​	$0.88​	$30.63​
12/8/2021 0:00​	ACF - Thistle & Rose - Ta	$200.80​	$8.78​	$209.58​

ACF - BULK - TAX

ACF - BULK

ACF - DRINKS - TAX

ACF - DRINKS

ACF - SWAG - TAX

ACF - SWAG

ACF - THISTLE & ROSE - TAX

ACF - THISTLE & ROSE

ACF - BAKED GOODS - TAX

ACF - BAKED GOODS

ACF - GIFT BOXES - TAX

ACF - GIFT BOXES

ACF - MISC - TAX

ACF - MISC

ACF - SHIPPING

E STORE SALES - TAX

E STORE SALES

FREIGHT & POSTAGE

ACF - MIXES - TAX

ACF - MIXES

ACF - CHOC COVERED ASSORT

GIFT CARDS SOLD

OVER/SHORT

 

[Fluff]

Any particular for a macro, as this can done with a simple formula

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Retail Tran Date	Product Department Name	Sum of Product Net Sales Amt	Sum of Product Tax Amount	Sales Total		Product Department Name	Sum of Product Net Sales Amt	Sum of Product Tax Amount	Sales Total
2	08/12/2021 00:00	ACF - Bulk - Tax	£14.25	£1.14	£15.39		ACF - Bulk - Tax	14.25	1.14	15.39
3	03/12/2021 00:00	ACF - Drinks - Tax	£18.00	£1.27	£19.27		ACF - Drinks - Tax	187.8	13.68	201.48
4	08/12/2021 00:00	ACF - Drinks - Tax	£13.50	£1.04	£14.54		ACF - Gift Boxes - No Tax	88.85	0	88.85
5	07/12/2021 00:00	ACF - Drinks - Tax	£8.10	£0.57	£8.67		ACF - Gift Boxes - Tax	249.7	14.7	264.4
6	02/12/2021 00:00	ACF - Drinks - Tax	£11.70	£0.90	£12.60		ACF - Misc - No Tax	4603.03	0	4603.03
7	10/12/2021 00:00	ACF - Drinks - Tax	£44.70	£3.27	£47.97		ACF - Misc - Tax	4141.49	291.63	4433.12
8	06/12/2021 00:00	ACF - Drinks - Tax	£31.50	£2.36	£33.86		ACF - Mixes	361.94	24.29	386.23
9	09/12/2021 00:00	ACF - Drinks - Tax	£60.30	£4.27	£64.57		ACF - Mixes - NT	78.95	0	78.95
10	02/12/2021 00:00	ACF - Gift Boxes - No Tax	£38.85	£0.00	£38.85		ACF - Swag - Tax	56.14	2.41	58.55
11	01/12/2021 00:00	ACF - Gift Boxes - No Tax	£50.00	£0.00	£50.00		ACF - Thistle & Rose - NT	17.56	0	17.56
12	06/12/2021 00:00	ACF - Gift Boxes - Tax	£59.95	£4.20	£64.15		ACF - Thistle & Rose - Ta	1319.9	72.82	1183.14
13	08/12/2021 00:00	ACF - Gift Boxes - Tax	£39.90	£0.00	£39.90
14	03/12/2021 00:00	ACF - Gift Boxes - Tax	£19.95	£1.40	£21.35
15	10/12/2021 00:00	ACF - Gift Boxes - Tax	£99.95	£7.00	£106.95
16	09/12/2021 00:00	ACF - Gift Boxes - Tax	£29.95	£2.10	£32.05
17	08/12/2021 00:00	ACF - Misc - No Tax	£461.54	£0.00	£461.54
18	01/12/2021 00:00	ACF - Misc - No Tax	£248.65	£0.00	£248.65
19	02/12/2021 00:00	ACF - Misc - No Tax	£150.00	£0.00	£150.00
20	09/12/2021 00:00	ACF - Misc - No Tax	£825.72	£0.00	£825.72
21	07/12/2021 00:00	ACF - Misc - No Tax	£2,597.60	£0.00	£2,597.60
22	10/12/2021 00:00	ACF - Misc - No Tax	£192.27	£0.00	£192.27
23	03/12/2021 00:00	ACF - Misc - No Tax	£127.25	£0.00	£127.25
24	02/12/2021 00:00	ACF - Misc - Tax	£2,886.36	£202.06	£3,088.42
25	10/12/2021 00:00	ACF - Misc - Tax	£171.19	£11.96	£183.15
26	07/12/2021 00:00	ACF - Misc - Tax	£42.16	£2.38	£44.54
27	09/12/2021 00:00	ACF - Misc - Tax	£255.02	£17.91	£272.93
28	03/12/2021 00:00	ACF - Misc - Tax	£226.78	£16.36	£243.14
29	06/12/2021 00:00	ACF - Misc - Tax	£137.80	£10.21	£148.01
30	08/12/2021 00:00	ACF - Misc - Tax	£149.83	£10.91	£160.74
31	01/12/2021 00:00	ACF - Misc - Tax	£272.35	£19.84	£292.19
32	09/12/2021 00:00	ACF - Mixes	£59.85	£4.19	£64.04
33	01/12/2021 00:00	ACF - Mixes	£28.80	£1.40	£30.20
34	06/12/2021 00:00	ACF - Mixes	£104.58	£7.31	£111.89
35	08/12/2021 00:00	ACF - Mixes	£19.95	£1.39	£21.34
36	07/12/2021 00:00	ACF - Mixes	£5.90	£0.41	£6.31
37	10/12/2021 00:00	ACF - Mixes	£73.70	£4.75	£78.45
38	03/12/2021 00:00	ACF - Mixes	£69.16	£4.84	£74.00
39	09/12/2021 00:00	ACF - Mixes - NT	£78.95	£0.00	£78.95
40	01/12/2021 00:00	ACF - Swag - Tax	£23.85	£0.00	£23.85
41	07/12/2021 00:00	ACF - Swag - Tax	£7.99	£0.56	£8.55
42	06/12/2021 00:00	ACF - Swag - Tax	£6.36	£0.51	£6.87
43	03/12/2021 00:00	ACF - Swag - Tax	£7.95	£0.64	£8.59
44	02/12/2021 00:00	ACF - Swag - Tax	£9.99	£0.70	£10.69
45	10/12/2021 00:00	ACF - Thistle & Rose - NT	£17.56	£0.00	£17.56
46	10/12/2021 00:00	ACF - Thistle & Rose - Ta	£516.48	£33.74	£550.22
47	02/12/2021 00:00	ACF - Thistle & Rose - Ta	£56.60	£2.96	£59.56
48	06/12/2021 00:00	ACF - Thistle & Rose - Ta	£168.51	£6.70	£175.21
49	07/12/2021 00:00	ACF - Thistle & Rose - Ta	£42.11	£1.20	£43.31
50	09/12/2021 00:00	ACF - Thistle & Rose - Ta	£162.65	£10.34	£172.99
51	03/12/2021 00:00	ACF - Thistle & Rose - Ta	£143.00	£8.22	£151.22
52	01/12/2021 00:00	ACF - Thistle & Rose - Ta	£29.75	£0.88	£30.63
53	08/12/2021 00:00	ACF - Thistle & Rose - Ta	£200.80	£8.78	$209.58
List

Cell Formulas
Range	Formula
G2:G12	G2	=UNIQUE(B2:B53)
H2:J12	H2	=SUMIFS(C:C,$B:$B,$G2#)
Dynamic array formulas.

 

[JakariKryze]

Any particular for a macro, as this can done with a simple formula

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Retail Tran Date	Product Department Name	Sum of Product Net Sales Amt	Sum of Product Tax Amount	Sales Total		Product Department Name	Sum of Product Net Sales Amt	Sum of Product Tax Amount	Sales Total
2	08/12/2021 00:00	ACF - Bulk - Tax	£14.25	£1.14	£15.39		ACF - Bulk - Tax	14.25	1.14	15.39
3	03/12/2021 00:00	ACF - Drinks - Tax	£18.00	£1.27	£19.27		ACF - Drinks - Tax	187.8	13.68	201.48
4	08/12/2021 00:00	ACF - Drinks - Tax	£13.50	£1.04	£14.54		ACF - Gift Boxes - No Tax	88.85	0	88.85
5	07/12/2021 00:00	ACF - Drinks - Tax	£8.10	£0.57	£8.67		ACF - Gift Boxes - Tax	249.7	14.7	264.4
6	02/12/2021 00:00	ACF - Drinks - Tax	£11.70	£0.90	£12.60		ACF - Misc - No Tax	4603.03	0	4603.03
7	10/12/2021 00:00	ACF - Drinks - Tax	£44.70	£3.27	£47.97		ACF - Misc - Tax	4141.49	291.63	4433.12
8	06/12/2021 00:00	ACF - Drinks - Tax	£31.50	£2.36	£33.86		ACF - Mixes	361.94	24.29	386.23
9	09/12/2021 00:00	ACF - Drinks - Tax	£60.30	£4.27	£64.57		ACF - Mixes - NT	78.95	0	78.95
10	02/12/2021 00:00	ACF - Gift Boxes - No Tax	£38.85	£0.00	£38.85		ACF - Swag - Tax	56.14	2.41	58.55
11	01/12/2021 00:00	ACF - Gift Boxes - No Tax	£50.00	£0.00	£50.00		ACF - Thistle & Rose - NT	17.56	0	17.56
12	06/12/2021 00:00	ACF - Gift Boxes - Tax	£59.95	£4.20	£64.15		ACF - Thistle & Rose - Ta	1319.9	72.82	1183.14
13	08/12/2021 00:00	ACF - Gift Boxes - Tax	£39.90	£0.00	£39.90
14	03/12/2021 00:00	ACF - Gift Boxes - Tax	£19.95	£1.40	£21.35
15	10/12/2021 00:00	ACF - Gift Boxes - Tax	£99.95	£7.00	£106.95
16	09/12/2021 00:00	ACF - Gift Boxes - Tax	£29.95	£2.10	£32.05
17	08/12/2021 00:00	ACF - Misc - No Tax	£461.54	£0.00	£461.54
18	01/12/2021 00:00	ACF - Misc - No Tax	£248.65	£0.00	£248.65
19	02/12/2021 00:00	ACF - Misc - No Tax	£150.00	£0.00	£150.00
20	09/12/2021 00:00	ACF - Misc - No Tax	£825.72	£0.00	£825.72
21	07/12/2021 00:00	ACF - Misc - No Tax	£2,597.60	£0.00	£2,597.60
22	10/12/2021 00:00	ACF - Misc - No Tax	£192.27	£0.00	£192.27
23	03/12/2021 00:00	ACF - Misc - No Tax	£127.25	£0.00	£127.25
24	02/12/2021 00:00	ACF - Misc - Tax	£2,886.36	£202.06	£3,088.42
25	10/12/2021 00:00	ACF - Misc - Tax	£171.19	£11.96	£183.15
26	07/12/2021 00:00	ACF - Misc - Tax	£42.16	£2.38	£44.54
27	09/12/2021 00:00	ACF - Misc - Tax	£255.02	£17.91	£272.93
28	03/12/2021 00:00	ACF - Misc - Tax	£226.78	£16.36	£243.14
29	06/12/2021 00:00	ACF - Misc - Tax	£137.80	£10.21	£148.01
30	08/12/2021 00:00	ACF - Misc - Tax	£149.83	£10.91	£160.74
31	01/12/2021 00:00	ACF - Misc - Tax	£272.35	£19.84	£292.19
32	09/12/2021 00:00	ACF - Mixes	£59.85	£4.19	£64.04
33	01/12/2021 00:00	ACF - Mixes	£28.80	£1.40	£30.20
34	06/12/2021 00:00	ACF - Mixes	£104.58	£7.31	£111.89
35	08/12/2021 00:00	ACF - Mixes	£19.95	£1.39	£21.34
36	07/12/2021 00:00	ACF - Mixes	£5.90	£0.41	£6.31
37	10/12/2021 00:00	ACF - Mixes	£73.70	£4.75	£78.45
38	03/12/2021 00:00	ACF - Mixes	£69.16	£4.84	£74.00
39	09/12/2021 00:00	ACF - Mixes - NT	£78.95	£0.00	£78.95
40	01/12/2021 00:00	ACF - Swag - Tax	£23.85	£0.00	£23.85
41	07/12/2021 00:00	ACF - Swag - Tax	£7.99	£0.56	£8.55
42	06/12/2021 00:00	ACF - Swag - Tax	£6.36	£0.51	£6.87
43	03/12/2021 00:00	ACF - Swag - Tax	£7.95	£0.64	£8.59
44	02/12/2021 00:00	ACF - Swag - Tax	£9.99	£0.70	£10.69
45	10/12/2021 00:00	ACF - Thistle & Rose - NT	£17.56	£0.00	£17.56
46	10/12/2021 00:00	ACF - Thistle & Rose - Ta	£516.48	£33.74	£550.22
47	02/12/2021 00:00	ACF - Thistle & Rose - Ta	£56.60	£2.96	£59.56
48	06/12/2021 00:00	ACF - Thistle & Rose - Ta	£168.51	£6.70	£175.21
49	07/12/2021 00:00	ACF - Thistle & Rose - Ta	£42.11	£1.20	£43.31
50	09/12/2021 00:00	ACF - Thistle & Rose - Ta	£162.65	£10.34	£172.99
51	03/12/2021 00:00	ACF - Thistle & Rose - Ta	£143.00	£8.22	£151.22
52	01/12/2021 00:00	ACF - Thistle & Rose - Ta	£29.75	£0.88	£30.63
53	08/12/2021 00:00	ACF - Thistle & Rose - Ta	£200.80	£8.78	$209.58
List

Cell Formulas
Range	Formula
G2:G12	G2	=UNIQUE(B2:B53)
H2:J12	H2	=SUMIFS(C:C,$B:$B,$G2#)
Dynamic array formulas.

but how to you get it to go between 2 different sheets? i need the summary to go on a different sheet because i will continue to move the items to others sheets and manipulate the blackboard sheet.

 

[Fluff]

Just add the sheet name of the data sheet to the formula.