Forum

Notifications
Clear all

Dynamically add YTD amounts for multiple rows / occurrence in excel

2 Posts
2 Users
0 Reactions
59 Views
(@mmisogwebu)
Posts: 1
New Member
Topic starter
 

i Have this file that i want to add YTD values and the Totals must change dynamically as i change the date in B1.

The formula i have used only add 1 row and not the second one.

Thanking you in advance for your assistance.

 

Regards

Mmiso

 
Posted : 24/06/2023 5:40 pm
Riny van Eekelen
(@riny)
Posts: 1206
Member Moderator
 

I have added three possible solutions to your file. Depending on the Excel version you are using, these may or may not work for you. And as often is the case with Excel, there are probably more ways to achieve the same outcome. Just couldn't think of any right now.

 
Posted : 26/06/2023 12:54 am
Share: