Changing column, not row

I have a formula below which works as i want it to.

When I drag the formula down i want the row to stay the same and the column to change, but the reverse happens.

I’ve looked into this and I just don’t understand the answers i’m getting.  If anyone could edit the formula so that i understand that would be great!

 

=sum(Financials!B11+Timesheet!B12+Timesheet!B12+Financials!B17+Financials!B20)

 

So essentially what would work for me is if all the B’s in the above changed to C’s in the next row, and then D’s in the next…


 

 


By: Adam

Leave a Reply

Your email address will not be published. Required fields are marked *