| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Sum Range Based on Date Chosen from Drop Down List
Hi,
Am Tue, 18 Nov 2014 05:36:14 -0800 (PST) schrieb : Jul-13 Aug-13 Sep-13 Oct-13............Total Value1 Value2 Value3 Value4........ Sum(n0:n+k) A1: Input Date try: =SUM(OFFSET($Q$4,,,,MATCH(A1,Q3:AZ3,0))) or =SUM(INDIRECT("Q4:"&ADDRESS(4,MATCH(A1,A3:AZ3,0))) ) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing range based on Date | Excel Discussion (Misc queries) | |||
| Generate date in cell on changing value in drop down list | Excel Programming | |||
| Source Range Data changing based on drop-down menu | Charts and Charting in Excel | |||
| How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
| My Excel drop-down list eliminates from list options chosen. Help | Excel Programming | |||
Threaded Mode
