Indirect Function with Subtotal

[rossd12]

Hello all,

I have a spreadsheet that has data running horizontally and at the bottom, the function =SUBTOTAL(104,L3:L65) to give me the maximum number in the column of data. This formula was then drug horizontally. I have since wanted to add cells to this, and have entered in the formula =SUBTOTAL(104,INDIRECT("L$3:L"&ROW()-1)) which indeed gives me the maximum number for column L but it only copies horizontally, and wont provide me with the next formula in line which would be =SUBTOTAL(104,INDIRECT("M$3:M"&ROW()-1)). Can someone please advise how to get this formula to drag across properly.

Thanks in advance!

 

[Aladin Akyurek]

=SUBTOTAL(104,L3:L65)

can be copied across as is. What is the problem with that?