Sum between rows

[Akbarov]

Hi community,

I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may etc.

Month names are in A1:A12
and numbers are in B1:B12

Can anybody help me to solve this problem please?

 

[AlphaFrog]

If the Data Validation lists are in C1 and C2

=SUM(OFFSET(B1,MATCH(C1,A1:A12,0)-1,,MATCH(C2,A1:A12,0)-MATCH(C1,A1:A12,0)+1))

 

[Nishant94]

You can try this:

Book1
	A	B	C	D	E	F
1	Jan	100		Start Date	End Date	Sum
2	Feb	10		02-02-2019	06-07-2019	270
3	Mar	30
4	Apr	90		Start Month	End Month	Sum
5	May	40		Feb	Jul	270
6	Jun	50
7	Jul	50
8	Aug	90
9	Sep	40
10	Oct	30
11	Nov	40
12	Dec	70
13
Sheet3

Cell Formulas
Range	Formula
F2	=SUM(INDEX(B1:B12,MATCH(TEXT(D2,"mmm"),A1:A12,0)):INDEX(B1:B12,MATCH(TEXT(E2,"mmm"),A1:A12,0)))
F5	=SUM(INDEX(B1:B12,MATCH(D5,A1:A12,0)):INDEX(B1:B12,MATCH(E5,A1:A12,0)))