Needing 2 formulas to work with the results from a UNIQUE function.

[brockk]

Greetings,

I'm trying to accomplish both a count of frequencies of certain criterias AND also to calculate the sum of those results from the count. My workbook has 2 sheets (DATA & TALLY) where in the Data sheet is located my Table with a sample of sales per transactions per day. I used a UNIQUE formula as to break-down sample sales categories and work like to tally both, units and
dollar amounts of each, but I am currently stumped on how to accomplish this since I am new with this UNIQUE function. Any help is greatly appreciated.

Book2
	A	B	C	D	E	F	G	H	I
6
7							Counts the frequencies of the 2 criterias (trans. # & tran type) per transaction. Lookup arrays are located in the "DATA" worksheet in Columns C & D respectively.	Sums the values found in Column H of the "DATA" worksheet where the 2 criterias are met from the results in Tally!G21.
8
9
10
11
12
13
14			*** (Original formula in cell Tally!C21) ***
15
16			=UNIQUE(Table1[[Date]:[Product Type]])
17
18
19
20			Date	Trans.	Trans. #	Tran Type	Qty	Total Sold
21			6/1/2023	1	1563	Activation	3	$ 70.00
22			6/1/2023	1	1563	Device	2	$ 1,999.98
23			6/1/2023	1	1563	Accessory	7	$ 235.91
24			6/1/2023	2	1567	Accessory	1	$ 39.99
25			6/2/2023	1	1575	Activation	6	$ 35.00
26			6/2/2023	1	1575	Device	6	$ 829.99
27			6/3/2023	0	0	N/A	0	$ -
28			6/6/2023	0	0	N/A	0	$ -
29			6/7/2023	1	1583	Activation	1	$ 35.00
30			6/7/2023	1	1583	Device	1	$ 829.99
31			6/7/2023	2	1584	Upgrade	1	$ 35.00
32			6/7/2023	2	1584	Device	1	$ 1,099.99
33			6/7/2023	2	1584	Accessory	3	$ 109.97
34			6/9/2023	1	1587	Activation	2	$ 35.00
35			6/9/2023	1	1587	Device	2	$ 92.00
36			6/9/2023	1	1587	Accessory	4	$ 129.97
37			6/9/2023	2	1592	Activation	1	$ -
38			6/9/2023	2	1592	Device	1	$ 228.00
39			6/9/2023	2	1592	Accessory	3	$ 89.97
40			6/10/2023	1	1601	Activation	2	$ 35.00
41			6/10/2023	1	1601	Device	1	$ 429.99
42			6/10/2023	1	1601	Accessory	3	$ 59.99
43			6/10/2023	2	1602	Activation	3	$ 105.00
44			6/10/2023	2	1602	Device	2	$ 1,899.99
45			6/10/2023	3	1609	Activation	1	$ 35.00
46			6/10/2023	3	1609	Device	1	$ 729.99
47			6/10/2023	3	1609	Accessory	2	$ 59.99
48			6/10/2023	4	1611	Accessory	1	$ 14.99
49			6/10/2023	5	1618	Activation	2	$ 70.00
50			6/10/2023	5	1618	Device	1	$ 428.00
51
52
53
Tally

Cell Formulas
Range	Formula
C21:F50	C21	=UNIQUE(Book1!Table1[[Date]:[Product Type]])
Dynamic array formulas.

 

[brockk]

Nevermind. After some Whiskey and a brain reset.... I figured my formula out. Now it is working. Thanks!

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.