I am in doubt if you are interested in a solution from me, but if you are you might want to take a look at the attached.
You wrote:
In other word the date of 11/18/2016 in column J would pick out the cost that goes with at date and would put the totals of that in AA7
As far as I can see the dates you mention are in column I, not in column J and they are not from 2016 but from 2015 while the date in AA6 is in year 2016.
I don't know if you just want to check for month and not for year. I have (in the formula in AA7) assumed you want to check for both year and month and accordingly I have temporarily changed the year in AA6 to 2015.
|