Hello Excel guru's,
Can the following formula be adapted to run over a dynamic range. Currently it will only work if the range is fixed to those rows containing data, just the first 21 rows.
I'm using Sumproduct because it will be pulling data from a closed workbook.![]()
=SUMPRODUCT(--('QO'!$J$12:J500="SQ"),--('QO'!$F$12:F500),--(MONTH('QO'!$E$12:E500)=MONTH(TODAY())))
Thank you
Bookmarks