New user looking for help creating excel 2010 formula.

[markl3396]

Sheet2 A	33 B	21 C	24 E
6/6/15
6/8/15
6/10/15

<tbody>
</tbody>

I have an excel sheet that I need to in sheet2 tell it to look at column A for date and then it looks at sheet1 column A for matching date. Then look at column D at that date for say number 21 and if that matches look at column E and add all amounts for that date and that number. Is this possible?

Sheet1 Date A	B	C	Code D	amount E	F
6/6/15	n	n	21	$300.50	n
6/8/15	n	n	24	250.00	n
6/8/15	n	n	21	225.00	n
6/10/15	n	n	21	300.00	n
6/10/15	n	n	21	285.50	n

<tbody>
</tbody>

Any help is appreciated.

 

[CodeNinja]

Paste this formula in cell B2 and copy over and down... Adjust ranges as necessary

=SUMIFS(Sheet1!$E$2:$E$6,Sheet1!$A$2:$A$6,Sheet2!$A2,Sheet1!$D$2:$D$6,Sheet2!B$1)

 

[markl3396]

Thanks for your help!