Need to add income only between 1st and 15th of each month

[RickyP]

I am a car salesman and made a sheet to track my sales from month to month. I would like to make a formula to only add the entries that fall between the 1st and 15th of each month to show me what my check will be for the first half of the month.
Column A has the dates and column J has the amount. I need to calculate only the first half of the month in J24 to know what my mid month check will be.

_____A.......................J
1___date______Total Owed on Check
2___1-Dec_________$100
3___10-Dec________$100
4___17-Dec________$100
.
.
24 __15th Check--->_$200

Thank you so much for any help. I have spent a couple of days trying to figure this out.

[daddylonglegs]

If you're only going to have sales for a single month on this worksheet then you can sum sales up the 15th with this formula

=SUMPRODUCT(--(DAY(A2:A20)<=15),J2:J20)

[RickyP]

Thank you!

[shg]

Please mark the thread as solved.



How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save