Forum Discussion
Solved
dynamic arrays
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.
Thank you sir.
3 Replies
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#)Thank you sir.
Mubeen1380 , you are welcome
