(V)LOOKUP Formula

[Dhira]

Hi ya'll,

I'm trying to create a formula in a column (C) that looks up whether there was a value in column E, and if there was, adds up the value of that row in column D
Then it only add to that total if there's a value in column E. otherwise, it returns a blank value in column C.

See below (without the proper formula):

Lookup.xlsx
	A	B	C	D	E
1	Incentive	Profit	Culmulative	Withdrawn	LP
2				$1.77
3				$3.70
4			$79.99	$79.99	0.7553
5				$2.71
6				$0.96
7				$1.20
8				$1.21
9				$1.12
10			$283.38	$203.39	1.705347
11				$1.63
12				$0.87
13				$0.78
14				$0.73
15				$0.90
16			$441.28	$157.90	1.01598
17				$2.14
18				$1.02
19				$0.88
20				$0.89
Sheet1

Cell Formulas
Range	Formula
C4	C4	=D4
C10	C10	=D4+D10
C16	C16	=D4+D10+D16

(My pathetic attempt began with =IF(VLOOKUP(*,E$2:E2,-1, ... then my brain froze .)
Help appreciated.

 

[Phuoc]

Try this:

Book1
	A	B	C	D	E
1	Incentive	Profit	Culmulative	Withdrawn	LP
2				1.77
3				3.7
4			79.99	79.99	0.7553
5				2.71
6				0.96
7				1.2
8				1.21
9				1.12
10			283.38	203.39	1.705346586
11				1.63
12				0.87
13				0.78
14				0.73
15				0.9
16			441.28	157.9	1.01598
17				2.14
18				1.02
19				0.88
20				0.89
21
Sheet1

Cell Formulas
Range	Formula
C2:C20	C2	=IF(E2="","",SUMIF($E$2:E2,"<>",$D$2:D2))

 

[Dhira]

Try this:

Book1
	A	B	C	D	E
1	Incentive	Profit	Culmulative	Withdrawn	LP
2				1.77
3				3.7
4			79.99	79.99	0.7553
5				2.71
6				0.96
7				1.2
8				1.21
9				1.12
10			283.38	203.39	1.705346586
11				1.63
12				0.87
13				0.78
14				0.73
15				0.9
16			441.28	157.9	1.01598
17				2.14
18				1.02
19				0.88
20				0.89
21
Sheet1

Cell Formulas
Range	Formula
C2:C20	C2	=IF(E2="","",SUMIF($E$2:E2,"<>",$D$2:D2))

Perfect. Thank you.