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 no...
Thank you sir.
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