|
|
|
|
#1
04-23-2016, 06:28 PM
|
|||
|
|||
Jeffrey according to what month. It will go starting in ( S4 ). If you could put the fomula in ( S4 ) then I can add them to the other months. Thank you
|
|
#2
04-23-2016, 06:40 PM
|
|||
|
|||
|
Change all of dates beginning in S3 to 1/1/2015, U3 to 2/1/2015, and so on
Now in S4 =SUMPRODUCT(--(MONTH($I$11:$I$40)&YEAR($I$11:$I$40)=TEXT(S3,"mmy yyy")),$J$11:$J$40) copy to U4, W4 etc
|
|
|
|
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