Formula to use a date to calculate an amount $.
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 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
Last edited by melvin1942; 04-23-2016 at 03:52 PM.
Reason: had a wrong word
|