I use a number of sumproduct formulas that have the start and end cell row hardcoded such as
The end cell in this case is 1500
How can I specify to use the end of available data data in column AP, A and H respectively instead of using the 1500? Next month it may need to be 1800, etc
Code:
=(SUMPRODUCT(
--((Closed!$AP$4:$AP$1500)=$B6),
--(MONTH(Closed!$A$4:$A$1500)=D$1),
Closed!$H$4:$H$1500))/1000
The end cell in this case is 1500
How can I specify to use the end of available data data in column AP, A and H respectively instead of using the 1500? Next month it may need to be 1800, etc