Home |
Search |
Today's Posts |
#1
|
|||
|
|||
YTD SUMIF based on current date
Hi,
I have a spreadsheet set up with months and revenue across columns, i.e: July;August;September;Oct....Total, YTD Total 70000;65000;80000, 72000...Total, YTD Total I also have a cell (I6) that updates and displays the current month when logged in. Assuming the months start at A1 and data on A2 - how would I go about creating a formula that only totals the YTD figure based on the current date? I.e. if the current month is November, the sum total for YTD only includes July, Aug, Sep, Oct, and Nov. (Please note the fiscal year starts 01 July). Thanks in advance. Please advise if you require any 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 | |||
Open file with variable date name based on current date | Excel Programming | |||
sumif with two conditions,current financial year date | Excel Worksheet Functions | |||
Conditional Formula based on current date | Excel Discussion (Misc queries) | |||
to-date total based on current date | Excel Worksheet Functions | |||
get back to day one based on current date | Excel Worksheet Functions |