How to sum customers sales excluding others by name? 🙌🙏

[Lacan]

Hello Guys,

Can you help with your excel expertise - the goal is to sum customers sales excluding others by name?
According with table below want to sum all customers with criteria: date (=>(01/01/2023)) and exclude customers B and C.
In cell I3 you have the pre-formula that I have tried and didn´t result but you can understand the structure and logic to easier finish it
In cell K9 you have the correct result according criteria.
Hope you can help.
Thank you very much.

Livro1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2						CRITERIA			TOTAL		TOTAL WITH THE CORRECT FORMULA SHOULD BE
3		CUSTOMER	DATE	SALES		EXCLUDE CUSTOMER	01/01/2023		#VALOR!		9
4		A	01/01/2022	5		B
5		A	02/01/2023	2		C
6		B	03/01/2023	2
7		C	04/01/2023	2
8		D	05/01/2023	5
9		E	06/01/2023	2
10
11
Folha4

Cell Formulas
Range	Formula
I3	I3	=SUMPRODUCT((B4:B9)*((C4:C9)>=G3)*(D4:D9))

 

[Dave Patton]

Sumifs.xlsm
	A	B	C	D	E	F	G	H	I
1
2						CRITERIA			TOTAL
3		CUSTOMER	DATE	SALES		EXCLUDE CUSTOMER	1-Jan-23		9
4		A	1-Jan-22	5		B
5		A	2-Jan-23	2		C
6		B	3-Jan-23	2
7		C	4-Jan-23	2
8		D	5-Jan-23	5
9		E	6-Jan-23	2
4d

Cell Formulas
Range	Formula
I3	I3	=SUMPRODUCT(--(1-ISNUMBER(MATCH(B4:B9,F4:F5,0))),--(C4:C9>=G3),(D4:D9))

 

[Lacan]

Sumifs.xlsm
	A	B	C	D	E	F	G	H	I
1
2						CRITERIA			TOTAL
3		CUSTOMER	DATE	SALES		EXCLUDE CUSTOMER	1-Jan-23		9
4		A	1-Jan-22	5		B
5		A	2-Jan-23	2		C
6		B	3-Jan-23	2
7		C	4-Jan-23	2
8		D	5-Jan-23	5
9		E	6-Jan-23	2
4d

Cell Formulas
Range	Formula
I3	I3	=SUMPRODUCT(--(1-ISNUMBER(MATCH(B4:B9,F4:F5,0))),--(C4:C9>=G3),(D4:D9))

Dear @Dave Patton,

Brilliant workes as a glove.
Thank you very much.
Hope you can help again next time.
All the best!

 

[Dave Patton]

Thanks for the feedback.