dynamic arrays

[Mubeen1380]

When I select month name from drop down list, I want to get corresponding services related to this month from data table in cell J19. Which formula is best to resolve this issue? This formula does not work 100%. =IFS(((I8:I12>=C1)*(I8:I12<=EOMONTH(C1,0))),N8:N12). The problem is that dynamic arrays move down. How I can stop it. Please watch gif image.

[#2]

@Mubeen1380 

You may simplify formula for the date

Array formulas could be

=FILTER($N$8:$N$12,($I$8:$I$12>=$C$1*($I$8:$I$12<=EOMONTH($C$1,0))))

and 

=SUMIFS($O$8:$O$12,$N$8:$N$12,J19#)

[#3 · Accepted solution]

@Sergei Baklan 

Thank you sir. 

[#4]

@Mubeen1380 , you are welcome