Hi,
I want to input a number every day, but the next day I want that cell to be blank so I can enter another number.
However, I also want to total the numbers for the week.
So, on the 1st I enter 5
On the 2nd the number 5 is not shown and I enter 10
On the 3rd the 10 is not shown and I enter 2
And so on to the end of the week.
Then, a separate cell would show the week's total.
Can this be done and if so, how?
Many thanks
Kelvin
I want to input a number every day, but the next day I want that cell to be blank so I can enter another number.
However, I also want to total the numbers for the week.
So, on the 1st I enter 5
On the 2nd the number 5 is not shown and I enter 10
On the 3rd the 10 is not shown and I enter 2
And so on to the end of the week.
Then, a separate cell would show the week's total.
Can this be done and if so, how?
Many thanks
Kelvin
