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!
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!
