kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have the following table:
I have my data in Table 1. In column D, I am calculating the accumulated sales. However, since some of the cells in column C has error value, the formula does seems to be able to return the correct accumulated value. If column C has error values, the accumulated total in column D should return the last accumulated value in column D. The correct results is in Table 2.
Is there a way to modify the current formula to achieve this ? Appreciate all the help.
I have the following table:
Book1 | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
7 | Table 1 | Table 2 | ||||
8 | Sales | Acc Sales | Acc Sales | |||
9 | 100 | 100 | 100 | |||
10 | #NUM! | #NUM! | 100 | |||
11 | 100 | #NUM! | 200 | |||
12 | #NUM! | #NUM! | 200 | |||
13 | #NUM! | #NUM! | 200 | |||
14 | #NUM! | #NUM! | 200 | |||
15 | 100 | #NUM! | 300 | |||
16 | 100 | #NUM! | 400 | |||
17 | #NUM! | #NUM! | 400 | |||
18 | #NUM! | #NUM! | 400 | |||
19 | #NUM! | #NUM! | 400 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D9 | D9 | =C9 |
D10:D19 | D10 | =D9+C10 |
I have my data in Table 1. In column D, I am calculating the accumulated sales. However, since some of the cells in column C has error value, the formula does seems to be able to return the correct accumulated value. If column C has error values, the accumulated total in column D should return the last accumulated value in column D. The correct results is in Table 2.
Is there a way to modify the current formula to achieve this ? Appreciate all the help.