Countifs - number of unique values each week

[adriandwor]

Hej everyone,

I'm trying to get some data for how many different days each particular week get sales orders, but I'm having difficulty coming up with the correct Countifs formula: Can anyone help?

So for example week#1/2/3 should yield a value of 1 because there was only one particular day where orders came in. Week number 4 should yield 3 different days, while week 6 there were 2 different days.

I tried to do it by counting unique values in column E for each week, but I keep getting wrong values.

Thank you so much for looking!

in progress 2023 (version 1).xlsx
	A	B	C	D	E		G
1	Uge	weekday	skjult weekday	Dato	Antal bookinger		Antal CC
2	1	søndag	1	01-01-2023	0		0
3	1	mandag	2	02-01-2023	0		0
4	1	tirsdag	3	03-01-2023	0		0
5	1	onsdag	4	04-01-2023	0		0
6	1	torsdag	5	05-01-2023	0		0
7	1	fredag	6	06-01-2023	0		0
8	1	lørdag	7	07-01-2023	0		0
9	1	søndag	1	08-01-2023	0		0
10	2	mandag	2	09-01-2023	0		0
11	2	tirsdag	3	10-01-2023	0		0
12	2	onsdag	4	11-01-2023	13		21
13	2	torsdag	5	12-01-2023	0		0
14	2	fredag	6	13-01-2023	0		0
15	2	lørdag	7	14-01-2023	0		0
16	2	søndag	1	15-01-2023	0		0
17	3	mandag	2	16-01-2023	0		0
18	3	tirsdag	3	17-01-2023	0		0
19	3	onsdag	4	18-01-2023	7		5
20	3	torsdag	5	19-01-2023	0		0
21	3	fredag	6	20-01-2023	0		0
22	3	lørdag	7	21-01-2023	0		0
23	3	søndag	1	22-01-2023	0		0
24	4	mandag	2	23-01-2023	0		0
25	4	tirsdag	3	24-01-2023	9		9
26	4	onsdag	4	25-01-2023	1		2
27	4	torsdag	5	26-01-2023	0		0
28	4	fredag	6	27-01-2023	5		4
29	4	lørdag	7	28-01-2023	0		0
30	4	søndag	1	29-01-2023	0		0
31	5	mandag	2	30-01-2023	0		0
32	5	tirsdag	3	31-01-2023	3		16
33	5	onsdag	4	01-02-2023	0		0
34	5	torsdag	5	02-02-2023	0		0
35	5	fredag	6	03-02-2023	0		0
36	5	lørdag	7	04-02-2023	0		0
37	5	søndag	1	05-02-2023	0		0
38	6	mandag	2	06-02-2023	0		0
39	6	tirsdag	3	07-02-2023	22		28
40	6	onsdag	4	08-02-2023	0		0
41	6	torsdag	5	09-02-2023	0		0
42	6	fredag	6	10-02-2023	4		3
43	6	lørdag	7	11-02-2023	0		0
44	6	søndag	1	12-02-2023	0		0
Days

Cell Formulas
Range	Formula
B2:B44	B2	=TEXT(WEEKDAY([@Dato]), "dddd")
C2:C44	C2	=WEEKDAY(D2)
E2:E44	E2	=COUNTIFS('Shipment Report Lines'!D:D, "<"&D3,'Shipment Report Lines'!D:D, ">="&D2)
G2:G44	G2	=ROUNDDOWN([@[Calculated Antal CC]], 0)
A3:A44	A3	=ISOWEEKNUM([@Dato])

 

[adriandwor]

anyone would be able to help here?