1st. In cell G10, I have a to-from destinations. Eg LAX-SFO-DEN.
I would like to have the “-“ indicate that cells I10:R10 should be added together and the total put in cell T10.
2nd. At the bottom of a column where I have a total, I would like to have this sum automatically sent to the top of the next page, in the first cell, in the corresponding column. Should I do this on the same sheet or make another sheet?
I am using Excell 2000
I am trying to make a log book.
I have tried every fx that I can think of
I would like to have the “-“ indicate that cells I10:R10 should be added together and the total put in cell T10.
2nd. At the bottom of a column where I have a total, I would like to have this sum automatically sent to the top of the next page, in the first cell, in the corresponding column. Should I do this on the same sheet or make another sheet?
I am using Excell 2000
I am trying to make a log book.
I have tried every fx that I can think of