Fantastic, I have a table with running totals, you have no idea how long I've been struggling with this!

Thank you!! I always enjoy your tutorials. I am a subscribed member of you channel and it has been the best thing I've done!! I have learned so much from you and your videos. Thank you!!

1) A thorough explanation of how the Row(s) & Columns(s) functions work. They can be confusing but they're essential. 2) The hide-zero tip is quite useful and makes a big difference in creating reports. 3) When I click "Click here to read in your browser" I get your "Table Running Total" page. Not a problem but I thought I'd mention it. 4) Thanks for all-your lessons are always helpful.

Thanks Mynda, the table tip was great!

I was always missing this one. Thanks ❤️

That's super helpful and definitely something I can see myself using. Cheers!

Thanks Mynda for these ideas. Liked the one in table with INDEX to handle deletion/insertion, really cool!

You are awesome, seems all my running totals issues will say goodbye from today, thanks a lot for making our lives easy.

Thank you for your valuable explanation .

Hello, you do an outstanding job with your examples and explanations. The topics are relevant and useful!

Very useful ... the second of the three methods shown (non Excel table) is elegantly simple. Thank you ... subscribed

Thank you so much! very much needed table referencing tips

This was a lifesaver - I had the problem with using subtotal due to wanting to keep a running total even if I filtered the date but the logic was the same. Thanks so much😀

Hi Mynda!Really Helpful Tips...Thank You :)

This was very helpful. Thank you.

Great explanation on running totals! One problem with the 3rd formula is slowness, when data is huge; The 1st formula is about speed, a modified version can solve the insert/delete row problem, = N(OFFSET([@RunningTotal], -1, 0)) + [@Values] You can avoid using OFFSET by creating a Named Range "CellAbove" and set it reference one cell above. becoming = N(CellAbove) + [@Value]

Great solution for tables. Thanks for sharing

I always learned something here and I love it thank you very much

Awesome tip especially for the Excel tables

Very effective tips and thanks for sharing

Mynda you’re a genius you that don’t you??! Thank you so much 😊

Clever…thank you. These are great tips.

Brilliant!! Thanks.

Thanks for sharing useful contents.

and, we can use pivot tables and PQ for running totals :) Thank you Mynda for this helpful tutorial

I always wondered why my tables didn't update properly in the running total columns; I'm now going to fix them all. Many thanks!!

Gracias...saludos desde México.

Thank you!!!

Thank You!!!

Nice tutorial..😀

lot of thanks to you .

Fantastic explanation. Thank you. Would you be able to show how to do a running total (stock on hand, i.e stock in and out) by product?

Super!

Mynda. Good material as always! You will need to add a dynamic array option sooner or later though. = SCAN(bFwd, Values, Addλ) where Addλ refers to =LAMBDA(u,v,u+v)

oh, that explains why I was getting errors with formulas used in a table; it wants to have the same formula in each row, and I must use the table structure reference to calculate the values. Can you elaborate in a separate video on this matter? As always, I love your videos.

Nice cool examples for running totals. You can also use the OFFSET FUNCTION inside the SUM Function to return expanding cell reference where the SUM aggregates the values within the range. =SUM($E$5:OFFSET($E$4,COUNT($E$5:E5),,,))

Hello. As usual, precise presentation of the problem. You are The Professional. By the way, I wanted to ask if there are any advantages / disadvantages to using this formula: [ =SUM(Table[[#Headers];[Values]]:[@Values]) ] with Your sum and index?

Thanks. Instead of Index table reference can be used as SUM(Table1[[#Headers],[Values]]:[@Values])

Many thanks Super useful, but can you please advise if i want to add a division componet how the formula will run? To illustrate, we have 3 columns, A, B, and C. Column C includes average cost, so in first row, i divide cost (A)over units to (B)come up with average cost per unit (C). In Row 2, i want the running total of Column (A)/ Cumulative total of Column (B), to come up wit new average in Column C, can you kindly advise how to do it ? Many thanks in advance

Hi , can we get the running total of calculated field, e.g I have a weekly data set of target vs actual, I want to calculate running achievement %(achievement for week 1+ week 2/target for week 1+ week 2 and so on)

Hi Mynda, another way, using dynamic arrays, and lambdas ar : any array, nonnumeric values will be considered 0’s k : integer, 0 or ignored, running total all the way down; k > 0, every k rows; k < 0 (-k), every other k-th row ARUNTOT = LAMBDA(ar, k, LET( n, ISNUMBER(ar), a, IF(n, ar, 0), r, ROWS(a), x, IF(k, MIN(INT(ABS(k)), r), r), c, COLUMNS(a), s, SEQUENCE(r), q, QUOTIENT(s - 1, x) + 1, m, MOD(s - 1, x) + 1, y, IF(s >= TRANSPOSE(s), IF(k >= 0, --(q = TRANSPOSE(q)), --(m = TRANSPOSE(m))), 0), MMULT(y, a) ) );

Nice, Mynda! Thank you! Quick Question, you are typing your formula in D4 and you are getting the values, but how come your formulas are showing in E4 and downward as well? I clicked on Show Formulas and it replaced my values and showed Formulas. I want to see Formulas in a separate column. Thanks

Another excellent tutorial - Quick question though - I import 3 bank accounts in CSV format into one excel table to keep tabs on my budget - Running totals are included in all 3 CSV downloads - I need to be able to extract the latest running total for each account as I update the table each month , I then use these 3 figures to update my dashboard - In words I need to search the table using the account number for each account and ignore all running totals except the very latest running total and use it to update my dashboard. Probably several ways to do this but I have not been successful so far. Any ideas welcome - thanks in advance.

Can Sumif be used to have an empty cell if there is no value. So lets say we want running value stops when there are not further values to add. I hope I made myself clear

😁If I had known about this, I could have saved many hours over the years.

How about 4th way =SUM($B$4:[@Value]) ? It does not break table formula and I does not need the extra 'index' function :)

I think using SCAN & LAMBDA is a better option to get running totals

I tried this as it is exactly what I need but I get the error too few arguments. Not sure why? Using a table and everything just as shown in video.

Thanks. Suppose that you have 'Manager' and 'Item' column in the table, want to have a running total for Manager&Item, how to reach this?

I would appreciate it if you could help me with the running balance for this data that i have in EXCEL TABLE. I have an opening balance on January 1st of RS. +10,000, received cash on January 5, Rs +20,000, and paid cash on January 8, Rs -4,000. I'm trying to figure out a formula for my data that i have in EXCEL TABLE to show the running balance after each transaction.

But what about if I add an entry to row 13, then 14, and so on?

Kindly zoom data cells because it hard to read in mobile screen

thanks, maybe microsoft will learn something from it.

I need help how to create a CPM in excel

Tip. Your video takes up a full screen, which is fine except on a mobile, some of the screen estate is taken up with a hole for a camera lens and some of the detail is not viable. Thank you 👍

I have this exact problem when adding rows within a finance sheet with money going in or out, however I don't know how to add your alteration. My formula is: =IF(C6="VIRGIN",L5+F6,IF(D6="VIRGIN",L5-F6,L5)) The L5+F6 or L5-F6 is I'm guessing where the SUM has to go so I tried =IF(C6="VIRGIN",SUM($L$5+F6,IF(D6="VIRGIN",SUM($L$5-F6,L5)))) but it returned FALSE. Can you see where I'm going wrong or doesn't your way apply here? ("F" is money coming in or going out, "L" is the running total, C&D identify the source of the transaction)

How to limit the running total to the last row in a range . This is to avoid having running total to have same values that goes beyond the range

My solution for Non_tables to get running totals: =BYROW(E5:E12,LAMBDA(a,SUM(E5:a))) =MAP(E5:E12,LAMBDA(a,SUM(E5:a))) IlirU

Ah, I always forget that INDEX can be used for things beyond INDEX&MATCH.

First view first like

I've been using excle the wrong way for the last 20 years, wow

We cannot recognize ur formullahs plz zoom

Or if you prefer SCAN: a : array (2D array, or vector) [d] : direction argument; 0 or omitted scan by array; >1 by clms;

I don't have F keys. :-(

Tables are wonky....Sorry. Not a fan. Love the other stuff.

I like those methods. As an alternative, try this simple one for your data in the Running Total field: =N(OFFSET([@[Running Total]],-1,))+[@Values] It works great for chequebooks, where you have Withdrawals, Deposits and Balance as field names. =N(OFFSET([@Balance],-1,))+[@Deposits]-[@Withdrawals]

=SUM($B$4:@VALUES) That seems to work too.😁