Sumifs

[ValpoMan]

I have a SUMIFS formula that will have 3 criterias....I need help with how to handle one of these criterias.....

Here is a sample of how my data is layed out:

[TABLE="width: 481"]
<tbody>[TR]
[TD="class: xl159, width: 82, bgcolor: #DDDDDD"]Posting Date
[/TD]
[TD="class: xl159, width: 203, bgcolor: #DDDDDD"]Document Header Text
[/TD]
[TD="class: xl159, width: 248, bgcolor: #DDDDDD"]Name
[/TD]
[TD="class: xl159, width: 108, bgcolor: #DDDDDD"]Val/COArea Crcy
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC ATT MOBILITY CHARGE
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC ATT MOBILITY JUN 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]39.09
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/1/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC ATT MOBILITY CHARGE
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC ATT MOBILITY MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]-39.09
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC VZ VERIZON WIRELESS
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC VERIZON WIRELESS JUN 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]175.47
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/1/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC VZ VERIZON WIRELESS
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC VZ VERIZON WIRELESS MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]-154.74
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD ATT MOBILITY CHARGE MA
[/TD]
[TD="class: xl161, bgcolor: transparent"]ATT MOBILITY MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]39.09
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD VZ VERIZON WIRELESS CH
[/TD]
[TD="class: xl161, bgcolor: transparent"]VERIZON WIRELESS MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]175.47
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC VZ VERIZON WIRELESS
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC VERIZON WIRELESS JUN 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]230.41
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/1/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC VZ VERIZON WIRELESS
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC VZ VERIZON WIRELESS MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]-231.70
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD VZ VERIZON WIRELESS CH
[/TD]
[TD="class: xl161, bgcolor: transparent"]VERIZON WIRELESS MAY 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]230.41
[/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]6/30/2014
[/TD]
[TD="class: xl161, bgcolor: transparent"]SD AC ATT MOBILITY CHARGE
[/TD]
[TD="class: xl161, bgcolor: transparent"]AC ATT MOBILITY JUN 2014
[/TD]
[TD="class: xl160, bgcolor: transparent"]38.50
[/TD]
[/TR]
</tbody>[/TABLE]

How can I sum IF the date is the last day of the month...in this case 6/30/14 but next month it will be 7/31/14 and so forth?

 

[RonB1111]

This formula will give the last day of a month:
=EOMONTH(A1,0)

 

[ValpoMan]

I am just unsure how to do a SUMIFS formula that will evaluate the date and if it is the last day of the month to inlcude it in the sum....

 

[Redwolfx]

Try

=SUMIFS(D2:D11,A2:A11,DATE(YEAR(A2),MONTH(A2)+1,0))

Or

=SUMIFS(D2:D11,A2:A11,EOMONTH(A2,0))

 

[ValpoMan]

WORKED! Thanks so much!

 

[Redwolfx]

Glad to help. Thanks for the feedback