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:

Date	Charge	Month	$ Paid
27-08-15	15.0	Sep-15	??????
01-09-15	20.0	Oct-15	??????
02-09-15	21.0
05-09-15	5.0
09-09-15	25.5
21-09-15	98.0
01-10-15	50.0
15-10-15	25.0

<tbody>
</tbody>

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.