Totaling charges against dates

[sgfifield78]

What I am trying to do is do a sumif() if the month of the date in Column A is = to the month-year (SEP-15) in column C. An example is as follows:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Charge[/TD]
[TD]Month[/TD]
[TD]$ Paid[/TD]
[/TR]
[TR]
[TD]27-08-15[/TD]
[TD]15.0[/TD]
[TD]Sep-15[/TD]
[TD]??????[/TD]
[/TR]
[TR]
[TD]01-09-15[/TD]
[TD]20.0[/TD]
[TD]Oct-15[/TD]
[TD]??????[/TD]
[/TR]
[TR]
[TD]02-09-15[/TD]
[TD]21.0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-09-15[/TD]
[TD]5.0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]09-09-15[/TD]
[TD]25.5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21-09-15[/TD]
[TD]98.0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-10-15[/TD]
[TD]50.0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15-10-15[/TD]
[TD]25.0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help would be greatly appreciated. Thanks.

 

[gaz_chops]

Welcome to the forum.

Try

=SUMPRODUCT(--(TEXT($A$2:$A$9,"my")=TEXT($C2,"my")),$B$2:$B$9)

[/FONT]
[TABLE="width: 260"]
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
  [TD="width: 65"]Date[/TD]
  [TD="width: 65"]Charge[/TD]
  [TD="width: 65"]Month[/TD]
  [TD="width: 65"]$ Paid[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]27/08/15[/TD]
  [TD="align: right"]15[/TD]
  [TD="class: xl64, align: right"]Sep-15[/TD]
  [TD="align: right"]169.5[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]01/09/15[/TD]
  [TD="align: right"]20[/TD]
  [TD="class: xl64, align: right"]Oct-15[/TD]
  [TD="align: right"]75[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]02/09/15[/TD]
  [TD="align: right"]21[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]05/09/15[/TD]
  [TD="align: right"]5[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]09/09/15[/TD]
  [TD="align: right"]25.5[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]21/09/15[/TD]
  [TD="align: right"]98[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]01/10/15[/TD]
  [TD="align: right"]50[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]15/10/15[/TD]
  [TD="align: right"]25[/TD]
  [TD][/TD]
  [TD][/TD]
 [/TR]
<!--EndFragment--></tbody>[/TABLE]
[FONT=Lucida Grande]

 

[sgfifield78]

Welcome to the forum.

Try

=SUMPRODUCT(--(TEXT($A$2:$A$9,"my")=TEXT($C2,"my")),$B$2:$B$9)

[TABLE="width: 260"]
<tbody>[TR]
[TD="width: 65"]Date[/TD]
[TD="width: 65"]Charge[/TD]
[TD="width: 65"]Month[/TD]
[TD="width: 65"]$ Paid[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]27/08/15[/TD]
[TD="align: right"]15[/TD]
[TD="class: xl64, align: right"]Sep-15[/TD]
[TD="align: right"]169.5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]01/09/15[/TD]
[TD="align: right"]20[/TD]
[TD="class: xl64, align: right"]Oct-15[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]02/09/15[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]05/09/15[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]09/09/15[/TD]
[TD="align: right"]25.5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]21/09/15[/TD]
[TD="align: right"]98[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]01/10/15[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]15/10/15[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

That is so awesome, it works... Thank you so much. The wealth of knowledge on here is amazing. I've been working on this problem just about all day and I got a solution in less than an hour.

 

[gaz_chops]

You're welcome, thanks for the feedback.