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:

Posting Date	Document Header Text	Name	Val/COArea Crcy
6/30/2014	SD AC ATT MOBILITY CHARGE	AC ATT MOBILITY JUN 2014	39.09
6/1/2014	SD AC ATT MOBILITY CHARGE	AC ATT MOBILITY MAY 2014	-39.09
6/30/2014	SD AC VZ VERIZON WIRELESS	AC VERIZON WIRELESS JUN 2014	175.47
6/1/2014	SD AC VZ VERIZON WIRELESS	AC VZ VERIZON WIRELESS MAY 2014	-154.74
6/30/2014	SD ATT MOBILITY CHARGE MA	ATT MOBILITY MAY 2014	39.09
6/30/2014	SD VZ VERIZON WIRELESS CH	VERIZON WIRELESS MAY 2014	175.47
6/30/2014	SD AC VZ VERIZON WIRELESS	AC VERIZON WIRELESS JUN 2014	230.41
6/1/2014	SD AC VZ VERIZON WIRELESS	AC VZ VERIZON WIRELESS MAY 2014	-231.70
6/30/2014	SD VZ VERIZON WIRELESS CH	VERIZON WIRELESS MAY 2014	230.41
6/30/2014	SD AC ATT MOBILITY CHARGE	AC ATT MOBILITY JUN 2014	38.50

<tbody>
</tbody>

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