|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
10-29-2007, 09:58 AM
|
|||
|
|||
|
Vlookup, sumproduct, if, or combonation of formulas?
I am working on a formula that is not working for me.
I am looking a range of time. Example: Months are consirdered periods. You have a period range of Jan '07- Dec '09. The period are represented as 200701-200912. So on one page I have a range of 200706-200805. I want to know what the range of this period is in months. I have the periods on another sheet with 1 next to it, the goal is for the formula to add the ones. Example: RangeStart (Period Code): 200705 RangeEnd (Period Code): 200910 *Range:* 30 months On another sheet I have: MonTh Period code 1 200701 1 200702 1 200703 1 200704 1 200705 1 200706 1 200707 1 200708 1 200709 1 200710 1 200711 1 200712 1 200801 1 200802 1 200803 1 200804 1 200805 1 200806 1 200807 1 200808 1 200809 1 200810 1 200811 1 200812 1 200901 1 200902 1 200903 1 200904 1 200905 1 200906 1 200907 1 200908 1 200909 1 200910 1 200911 1 200912 My goal is to come have a formula for the *Range* cell. I want it to go over to the other page and look at the table and find those two (200705, 200910) and add up the ones to give me the range. Thank you in advance. Last edited by Roxy; 10-29-2007 at 10:00 AM. 
|
|
#2
10-29-2007, 10:06 AM
|
||||
|
||||
|
Assuming your table is in columns A & B, then try:
=SUMIF(B:B,">="&E1,A:A)-SUMIF(B:B,">"&E2,A:A) where E1 contains Start date code and E2 contains end date code.
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
