summing values between two items

[Hasson]

hi experts
I have two data validation A7,B7 are linked with row1 when I select two datavalidations then should sum values in row2 which locates between two cells A7,B7 .
the result should be in CELLS D8

1234.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM
1	AA1	AA2	AA3	AA4	AA5	AA6	AA7	AA8	AA9	AA10	AA11	AA12	AA13	AA14	AA15	AA16	AA17	AA18	AA19	AA20	AA21	AA22	AA23	AA24	AA25	AA26	AA27	AA28	AA29	AA30	AA31	AA32	AA33	AA34	AA35	AA36	AA37	AA38	AA39	AA40	AA41	AA42	AA43	AA44	AA45	AA46	AA47	AA48	AA49	AA50	AA51	AA52	AA53	AA54	AA55	AA56	AA57	AA58	AA59	AA60	AA61	AA62	AA63	AA64	AA65	AA66	AA67	AA68	AA69	AA70	AA71	AA72	AA73	AA74	AA75	AA76	AA77	AA78	AA79	AA80	AA81	AA82	AA83	AA84	AA85	AA86	AA87	AA88	AA89	AA90	AA91
2	123	22	34	56	77	7876	8999	54	23	555	777	990	987	2344	240	250	111	222	435	290	300	310	3456	330	666	663	667	370	678	90	78	90	44	430	440	450	460	470	480	490	500	510	520	530	540	550	560	570	580	590	600	610	620	630	640	650	660	670	680	690	700	710	720	730	740	750	760	770	780	790	800	810	820	830	840	850	860	870	880	890	900	910	920	930	940	950	960	970	980	990	1000
3
4
5
6
7	AA5	AA16		VALUE
8
9
10
SHEET1

Cells with Data Validation
Cell	Allow	Criteria
A7:B7	List	=$A$1:$Y$1

 

[Eric W]

Try:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM
1	AA1	AA2	AA3	AA4	AA5	AA6	AA7	AA8	AA9	AA10	AA11	AA12	AA13	AA14	AA15	AA16	AA17	AA18	AA19	AA20	AA21	AA22	AA23	AA24	AA25	AA26	AA27	AA28	AA29	AA30	AA31	AA32	AA33	AA34	AA35	AA36	AA37	AA38	AA39	AA40	AA41	AA42	AA43	AA44	AA45	AA46	AA47	AA48	AA49	AA50	AA51	AA52	AA53	AA54	AA55	AA56	AA57	AA58	AA59	AA60	AA61	AA62	AA63	AA64	AA65	AA66	AA67	AA68	AA69	AA70	AA71	AA72	AA73	AA74	AA75	AA76	AA77	AA78	AA79	AA80	AA81	AA82	AA83	AA84	AA85	AA86	AA87	AA88	AA89	AA90	AA91
2	123	22	34	56	77	7876	8999	54	23	555	777	990	987	2344	240	250	111	222	435	290	300	310	3456	330	666	663	667	370	678	90	78	90	44	430	440	450	460	470	480	490	500	510	520	530	540	550	560	570	580	590	600	610	620	630	640	650	660	670	680	690	700	710	720	730	740	750	760	770	780	790	800	810	820	830	840	850	860	870	880	890	900	910	920	930	940	950	960	970	980	990	1000
3
4
5
6
7	AA5	AA16		23172
Sheet4

Cell Formulas
Range	Formula
D7	D7	=SUM(INDEX(A2:CM2,MATCH(A7,A1:CM1,0)):INDEX(A2:CM2,MATCH(B7,A1:CM1,0)))

 

[Hasson]

great ! it's quick answer
thanks so much

 

[Eric W]

Happy to help! ?