Sumif problem

[iffi]

summary

<table style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:92px;"><col style="width:71px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td></tr><tr style="height:21px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">7</td><td> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">Date</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">Amount</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">8</td><td> </td><td style="text-align:right; ">4-Apr-11</td><td style="text-align:right; ">100</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">9</td><td> </td><td style="text-align:right; ">7-Apr-11</td><td style="text-align:right; ">500</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">10</td><td> </td><td style="text-align:right; ">20-Apr-11</td><td style="text-align:right; ">100</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">11</td><td> </td><td style="text-align:right; ">28-Apr-11</td><td style="text-align:right; ">300</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">12</td><td> </td><td style="text-align:right; ">10-May-11</td><td style="text-align:right; ">400</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">13</td><td> </td><td style="text-align:right; ">15-May-11</td><td style="text-align:right; ">550</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">14</td><td> </td><td style="text-align:right; ">11-Jun-11</td><td style="text-align:right; ">670</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">15</td><td> </td><td style="text-align:right; ">9-Jun-11</td><td style="text-align:right; ">480</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">16</td><td> </td><td style="text-align:right; ">18-Jun-11</td><td style="text-align:right; ">170</td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">17</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">18</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr style="height:21px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">19</td><td> </td><td> </td><td style="background-color:#808080; color:#ffffff; font-weight:bold; font-size:12pt; ">April</td><td style="background-color:#808080; color:#ffffff; font-weight:bold; font-size:12pt; ">May</td><td style="background-color:#808080; color:#ffffff; font-weight:bold; font-size:12pt; ">June</td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">20</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">21</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr></tbody></table>

I want to use sumif function in D20 Cell to sum up all the amount of april month only and same for may and june month, it seems easy but i tried myself all the way but i was not able to do it, please kindly help me

Thanks in advance to all the generous experts here helping people.

 

[VoG]

Try like this

Excel Workbook
	C	D	E	F
7	Date	Amount
8	04-Apr-11	100
9	07-Apr-11	500
10	20-Apr-11	100
11	28-Apr-11	300
12	10-May-11	400
13	15-May-11	550
14	11-Jun-11	670
15	09-Jun-11	480
16	18-Jun-11	170
17
18
19		April	May	June
20		1000	950	1320
Sheet9

 

[iffi]

wow, it worked great, Thank you very very much VoG, u r great, i really appreciate it.

but if u don't mind sir, would u plzz explain me this formula step by step so that i can understand the formula how it is working so that i can apply this in other situation when i need it. Thanks again.

 

[VoG]

This may help you http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[iffi]

Thanks VoG, i got it