There you go melvin1942!

Attached Files

Northpoint 8N Restoratio Financial 2015 _ 2016_melvin1942.xlsx (37.0 KB, 19 views)

Thanks for send this back, but I cannot open it with excel. it does not show as an Excel program it only show as file. I had this happen one other time and had to have it sent to my email address. If you could do that it would be helpful.

melvin1942

If you would send this file by email so I can open it. I have down loaded it three times and tries to open it. It does not show as a Excel file so it will not let me open it. My email address is.

leroy9804@aol.com

Thank you.
melvin1942

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.

Attached Files

Northpoint_3.xlsx (37.2 KB, 8 views)