Morning All,
I have a Cash sheet with totals on it but I can not figure something out.
When entering £1.50 into K6, L6 shows £1.50
When entering £2.00 into K7, L7 shows £3.50 and so on, but I do not want to see £3.50 in all the cells in L but when I enter figures into the other cell I want the L column to change to the new calculation and so on.
L39 will show the sum of column K. I hope this makes sence, I am not very good at explaining things. I have attached a copy of the cash sheet to hopefuly explain it self.
Shazz
xx
I have a Cash sheet with totals on it but I can not figure something out.
When entering £1.50 into K6, L6 shows £1.50
When entering £2.00 into K7, L7 shows £3.50 and so on, but I do not want to see £3.50 in all the cells in L but when I enter figures into the other cell I want the L column to change to the new calculation and so on.
L39 will show the sum of column K. I hope this makes sence, I am not very good at explaining things. I have attached a copy of the cash sheet to hopefuly explain it self.
Shazz
xx