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:
<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?
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?
Last edited: