What I am trying to do is to put a date like 1/1/2016 say in column a1 and another date 01/15/2016 in A3 then put an amount $300.00 in C1 and $200.00 in C3 . Then have the formula look at the dates in A1 and A3 and sum up the amount in C1 and C3. In other words it would look at the entire A column for any date the that has 1/2016 in it and then find the amounts in column C that goes with that month.

I hope you under stand what I mean I am not very good at explaining what I want.

Thank you for your time.

melvin1942