|
|
|
|
#1
05-19-2016, 12:05 PM
|
|||
|
|||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Calculate amount of entered fields
|
sp1d3r69 | Excel | 3 | 01-26-2015 07:35 AM |
| calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
| Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
|
Formula to auto calculate Day of the week based on Date
|
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
|
What formula should I use to calculate commission?
|
grs | Excel | 3 | 02-21-2011 02:17 AM |
Windows 10 
Office 2007
Hybrid Mode