Share via

Excel Help - Formula - dynamic YTD

Anonymous
2020-12-16T13:20:58+00:00

I want to be able to put a dynamic YTD figure in B17 for the data above

I am looking for a dynamic formula to fill B17 with a YTD figure of C vs B essentially

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-16T15:09:29+00:00

    Try this

    convert the data to a table by pressing ctrl+t, by default table name will be Table1

    use the following formula

    b17:=SUM(IF(YEAR(TODAY())=YEAR(Table1[Period]),Table1[Target]))

    c17:=SUM(IF(YEAR(TODAY())=YEAR(Table1[Period]),Table1[Actual]))

    0 comments
  2. Anonymous
    2020-12-16T18:43:12+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    With PivotChart and comparative %.

    No formulas, no VBA macro.

    https://www.mediafire.com/file/q87r1e3bj9lo2nw/12\_16\_20.xlsx/file

    https://www.mediafire.com/file/jp73wgdv6ndyeri/12\_16\_20.pdf/file

    0 comments
  3. Ashish Mathur 101K Reputation points Volunteer Moderator
    2020-12-16T23:41:49+00:00

    Hi,

    In cell B17, enter this formula

    =sumif(C3:C14,<>,B3:B14)

    In cell C17, enter this formula

    =sum(C3:C14)

    Hope this helps.

    0 comments
  4. Anonymous
    2020-12-18T15:00:38+00:00

    Hi Luke Edwards,

    Have you solved the Excel formula question? If not, please feel free to post back, we will continue to help you. 😊

    Best regards,

    Cindy

    0 comments