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. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-12-16T13:25:23+00:00

    In E3:

    =SUM(C$2:C2)

    Fill down to E14.

    0 comments
  2. Anonymous
    2020-12-16T13:28:04+00:00

    That's not worked

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

    So once I enter something into C5, B17 will update with the YTD figure vs the target in B YTD

    0 comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-12-16T13:39:05+00:00

    I'm sorry, I don't understand.

    0 comments
  4. Anonymous
    2020-12-16T13:44:32+00:00

    Basically every month Column C - Actual will be updated

    I then want to calculate a figure to put in B17 of the YTD amount in Column C (Actual) vs the YTD amount in Column B (Target).

    I need this to be dynamic

    0 comments
  5. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-12-16T13:54:32+00:00

    Can you explain what B17 should contain in your screenshot?

    And what should it contain if I enter (for example) 8 in cell C5?

    0 comments