populate & sum numeric data based on two dates and sheet name using options

[Abdo]

Hello
I have two sheets contains data .
what I want in OUTPUT sheet when write dates in D3,E3 and sheet name in F3 and select optionbutton1 or optiobutton2 (ACTIVE X)
then should show data from row7 by summing the numbers within two dates and sheet name and optionbuttons .
the dates should match with column B in any sheet and the optionbutton will match with column D
my format date DD/MM/YYYY

ABB.xlsm
	A	B	C	D	E
1	ITEM	DATE	REF	CONDITION	BALANCE
2	1	01/01/2023	RE45666	AA	1200.00
3	2	01/01/2023	RE45667	PP	2000.00
4	3	01/01/2023	RE45668	AA	2200.00
5	4	01/01/2023	RE45669	PP	1000.00
6	5	01/01/2023	RE45670	AA	1500.00
7	6	02/01/2023	RE45671	AA	2000.00
8	7	02/01/2023	RE45672	AA	2200.00
9	8	02/01/2023	RE45673	AA	2400.00
10	9	02/01/2023	RE45674	PP	2600.00
CCR

ABB.xlsm
	A	B	C	D	E
1	ITEM	DATE	REF	CONDITION	BALANCE
2	1	01/01/2023	CV455-900	PP	1,200.00
3	2	01/01/2023	CV455-901	PP	2,000.00
4	3	01/01/2023	CV455-902	AA	2,200.00
5	4	01/01/2023	CV455-903	PP	1,000.00
6	5	01/01/2023	CV455-904	PP	1,500.00
7	6	02/01/2023	CV455-905	PP	2,000.00
8	7	02/01/2023	CV455-906	AA	2,200.00
9	8	02/01/2023	CV455-907	AA	2,400.00
CVF

ABB.xlsm
	A	B	C	D	E	F
1
2				FROM DATE	TO DATE	SHEET NAME
3
4
5
OUTPUT

the result in row7 after writing into cells and select optionbutton

ABB.xlsm
	C	D	E	F
1
2		FROM DATE	TO DATE	SHEET NAME
3		01/01/2023	02/01/2023	CCR
4
5
6
7		ITEM	BALANCE
8		1	11500
OUTPUT

the data could be 4000 rows for each sheet
thanks in advance

 

[Abdo]

@Abdo, are you using a 2010 version or a 2019 version in this situation?

currently 2013, 2019.

 

[awoohaw]

currently 2013, 2019.

Okay, Well, I errored in thinking that you version (2019) did not need to commit SUM Function Array Formulas without the CSE (CNTL-SHFT-ENTR) keystroke, which works for 2019, I'm not sure about 2013, but I think it does. I am pretty sure SUMPRODUCT does not need it though.

Best Wishes!