Lawrence Salvucci
asked on
Set formula to find last row of data
I have a formula that I need to keep changing as I add rows of data. How can I change this formula to always adjust itself to finding the last row of data when I add new rows? I read something about using the OFFSET function but not sure how to use it.
SUMPRODUCT(--(Database!$H$4:$H$35020=$A$10),--(YEAR(Database!$C$4:$C$35020)=YEAR(C$18)),--(MONTH(Database!$C$4:$C$35020)=MONTH(C$18)),--(Database!$AP$4:$AP$35020=$B19),(Database!$V$4:$V$35020))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER