Why the formula to get Dynamic named range doesn't work?

Hi,

I would like to get a dynamic range of a column with values. I tried two formula. However, only works. Not sure why the other one doesn't work. Please see attached Example file.

1. =OFFSET(Parameter_New!$C$5,0,0,COUNTA(Parameter_New!$C$5:$C$34),1) ----Works
2. =OFFSET(Parameter_New!$C$5,0,0,MATCH("Grand Total",C:C,0)-ROW($C$5)+1,1) ---- Doesn't work

I found out it is due to ROW($C$5). If I use 5 to replace ROW($C$5), the formula will work.

Could you please let me know why and how to fix it by using Row?