Hi,
I have this formula to find the cell ID of the last row in a column:
=ADDRESS(MATCH(9.99999999999999E+307,'IT hours'!A:A),1)

eg.. if the result is $A$933

I want to use this Cell ID in a SUMIF formula.
SUMIFS('IT Ratio'!$A$4:$A$933,'IT Ratio'!$A$4:$A$118,'For SLR'!E$17,.....)
ie. to replace the $A$933 in the formula, so that the sumifs will work
dynamically.

May I know what should be the syntax for this?
Appreciate any help.
Thanks,
YY.