absolutelyprobable
New Member
- Joined
- Jan 30, 2006
- Messages
- 37
- Office Version
- 2019
- Platform
- Windows
Hi,
Depending on what day it is (in cell A1), I want my total (in cell B2) to show the sum of figures in each row up to and including that day.
I've got a formula that does this but it's long which means I can't exstend this to cover two working weeks at a time.
Can anyone figure if there is/are function/s that will provide a neat solution?
Gareth
Depending on what day it is (in cell A1), I want my total (in cell B2) to show the sum of figures in each row up to and including that day.
I've got a formula that does this but it's long which means I can't exstend this to cover two working weeks at a time.
Can anyone figure if there is/are function/s that will provide a neat solution?
Gareth
Book1.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 21/09/2006 | 18/09/2006 | 19/09/2006 | 20/09/2006 | 21/09/2006 | 22/09/2006 | ||||
2 | 10 | 1 | 2 | 3 | 4 | 5 | ||||
Sheet2 |