SUMIF & VLOOKUP Function

[Mark Sanders]

Dear helpers,

I am having difficulty creating a formula that I believe requires both a SUMIF and VLOOKUP function. I have been looking through other forums and Excel online help for a solution however haven't found one.

My table looks like this:

Row / Column	A	B	C	D	E
1	Date	Source	Cost	Date	Total
2	4-Mar	Phone bill	$ 55.00	1-Mar
3	6-Mar	Power	$ 125.00	2-Mar
4	7-Mar	Petrol	$ 34.00	3-Mar
5	7-Mar	Toms Present	$ 20.00	4-Mar
6	14-Mar	Lunch & Choc	$ 8.50	5-Mar
7	15-Mar	Groceries	$ 22.00	6-Mar
8				7-Mar
9				8-Mar
10				9-Mar
11				10-Mar
12				11-Mar
13				12-Mar
14				13-Mar
15				14-Mar
16				15-Mar
17				16-Mar

<colgroup><col style="width: 85pt; mso-width-source: userset; mso-width-alt: 3616;" width="113"> <col style="width: 66pt;" width="88"> <col style="width: 74pt; mso-width-source: userset; mso-width-alt: 3168;" span="2" width="99"> <col style="width: 66pt;" span="2" width="88"> <tbody>
</tbody>

The formula I want to create needs to be entered in cell E2, with the solution being the sum of cost (column C) for the referenced day in the previous column. Eg. the formula looks up D2 amongst the array A2:C17 and provides the total. The 7-Mar referenece (cell E8) shoud equal $54.

I hope this makes sense and would appreciate any advice. If there is any online information a helper can steer me too (or a formula) I will be very thankful.

Best wishes,

Mark Sanders

 

[JoeMo]

In E2 and copy down:
=SUMIF($A$2:$A$7,D2,$C$2:$C$7)

 

[konew1]

=sumproduct(--($a$3:$a$18=d3),($c$3:$c$18))

 

[Mark Sanders]

In E2 and copy down:
=SUMIF($A$2:$A$7,D2,$C$2:$C$7)

Many thanks JoeMo. Much appreciated.