Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down List Dependant Formula
Hi,
I have a drop down list where a user can select the month (cell I6). I also have a data set on another sheet like this: jul;aug;sep;oct;nov...Total;YTD Total 100;250;350;420;530...Total;YTD Total Assume date range starts in A1 and figures start in A2. Also, the fiscal year starts in July, not January. What I'd like to have happen is that depending on the month selected from the list - for that selection to drive a YTD sum calculation/function, i.e. If the user selects October from dropdown list - then the YTD total sum will only include months upto and including October only (i.e. July, Aug, Sep, Oct). Thanks in advance. Happy to help with further details. |
#2
|
|||
|
|||
Thanks anyway. Have figured it out from another forum.
Answer for those interested: =SUM("start of data range":INDEX("start of data range:end of data range,MATCH(dropdown list with months,start of month range:end of month range,0))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation dependant drop down on unsorted list | Excel Worksheet Functions | |||
Dependant drop down list with more than two words in the options | Excel Worksheet Functions | |||
drop down list dependant of previous selection | Excel Worksheet Functions | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop-down list dependant on another cell value | Excel Programming |