Hi,I have this formula:
=SUMPRODUCT(SUBTOTAL(3,OFFSET('ANALYSIS'!$E$1:$E$8865,ROW('ANALYSIS'!$E$1:$E$8865)-MIN(ROW('ANALYSIS'!$E$1:$E$8865)),,1))*('ANALYSIS'!$E$1:$E$8865=B2))
In my worksheet, I also have a column D, which contains dates.
Is it possible to add a date range (e.g Sep.01 - Sep.30) in the above formula ,so I can filter more my results ?
=SUMPRODUCT(SUBTOTAL(3,OFFSET('ANALYSIS'!$E$1:$E$8865,ROW('ANALYSIS'!$E$1:$E$8865)-MIN(ROW('ANALYSIS'!$E$1:$E$8865)),,1))*('ANALYSIS'!$E$1:$E$8865=B2))
In my worksheet, I also have a column D, which contains dates.
Is it possible to add a date range (e.g Sep.01 - Sep.30) in the above formula ,so I can filter more my results ?