Populate Last Value in Column and Ignore Errors

[kumara_faith]

Hi,

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.

 

[Fluff]

How about

=SUM(IFERROR(C$9:C9,0))

 

[kvsrinivasamurthy]

In D9 then copy down

=AGGREGATE(9,6,$C$9:$C9)

 

[shaowu459]

=SUMIF(C$9:C9,">0")

 

[kumara_faith]

Hi Fluff, kvsrinivasamurthy and shaowu459,

Thank you for the solution. It worked and appreciate your patience and valuable time. Have a great day ahead.?

 

[Fluff]

Glad we could help & thanks for the feedback.