Formula to get a month total.
What I am trying to do is to put a date like 1/1/2016 say in column G6 and another date 01/15/2016 in G7 then put an amount $300.00 in E6 and $200.00 in E7 . Then have the formula look at the dates in G6 and G7 and sum up the amount in E6 and E7. In other words it would look at the entire G column for any date the that has 1/2016 in it and then find the amounts in column E that goes with that month, and total all of that month up in the months to the right N3 and so on.
We have gone through this before and I am trying to use the formula in a different spread sheet I am sending it to you.
Thank you for your time.
melvin1942
Last edited by melvin1942; 05-19-2016 at 03:18 PM.
|