excel formula sum date column in error

[Sourdough123]

Excel365formula.xlsm
	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8			Rep Name	Date	Tender #	Job Name	Job Value	Sqm
9			Aretha	29-11-2022	Elk Hermanus	ELKHER0425	30,787.00	-
10			Aretha	29-11-2022	Elk Hermanus	ELKHER0425	-	8.31
11			Aretha	22-11-2022	Elk SSW	ELKS0388	12,589.00	3.00
12			Aretha	21-11-2022	Spotlight	SP0601	37,313.00	-
13			Aretha	11-11-2022	Spotlight	SP1439	14,378.00	3.48
14			Aretha	10-11-2022	Spotlight	SP1407	155,992.00	4.29
15			Aretha	10-11-2022	Spotlight	SP1407	-	-
16			Aretha	08-11-2022	Spotlight	SP1406	35,926.00	-
17			Aretha	08-11-2022	Spotlight	SP1406	-	-
18			Aretha	08-11-2022	Spotlight	SP1406	-	10.79
19			Aretha	26-11-2022	Spotlight	SP1303.4	224,650.00	20.66
20			Total	10-09-3251			511,635.00	50.53
21			Steffan	24-11-2022	TERRY	SMM0644	2,196.00	0.90
22			Steffan	01-11-2022	Glenson	SMM0597	13,211.00	3.88
23			Steffan	01-11-2022	GLENSON	SMM0597	-	-
24			Steffan	04-11-2022	Core Interiors	CCI000214NC	1.00	4.27
25			Steffan	11-11-2022	TANGERINE PROJECTS	TAN0010	52,120.00	8.51
26			Steffan	11-11-2022	TANGERINE PROJECTS	TAN0010	-	-
27			Steffan	30-11-2022	Interior Fusion	INF0263.4	63,657.00	13.16
28			Steffan	30-11-2022	Interior Fusion	INF0263.4	-	-
29			Total	28-12-2882			131,185.00	30.72
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Sheet3

Cell Formulas
Range	Formula
C9:H29	C9	=DROP(REDUCE(0,UNIQUE(TAKE(X9#,,1)),LAMBDA(x,y,LET(s,FILTER(X9#,TAKE(X9#,,1)=y),VSTACK(x,s,HSTACK("Total",IFERROR(BYCOL(DROP(s,,1),LAMBDA(z,SUM(--z))),"")))))),1)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C10:H45	Expression	=$C10="Total"	text	NO

Can you help with formula not to sum date column please
Thanks
BB

 

[Joe4]

Duplicate to: excel formula sum date column in error

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.