How to SUM Totals At Bottom of a Column Dynamically - Excel VBA Is Fun!

This was super helpful! Do you have a video explaining how to do this same VBA sum concept except with summing a row horizontally when the last cell in that row is changing as data is added/removed?

Thanks for the help

Good one. Thanks 👍

this is confusing. seems you would know how to do it before making the video?

Thankyou^^

Hello can i have the code please

Thank you, you explained it very well, and I love the simplicity. I was stuck trying to combine multiple for loops, but this made perfect sense, and it actually worked! Thanks again!

I'm trying to figure out how to design a model with a message box that requests a positive integer input and then populates a list of all the odd integers that occur before that positive integer entered and also provides the sum of all those negative integers at the bottom of the data set. So for example, if the user enters 8, then there will be a range of negative integers including 1, 3, 5, and 7 and a resulting sum of 16. How can this be achieved?

You just saved me. Your video is clear, to the point, and actually really interesting.
I hope you have a great day.
All the best.

Thanks a lot it help me to find the solutions

i m facing an error in the first line of code runtime error 9 subscript out of range

Definitely a Geek! 🤦‍♂️ Way above what I needed..

Could you please add the vba
The link does’nt work

Hello , I am wondering if you can help me with the following task: I have two work books, the first one is to create invoice with customer information and purchasing details , the second workbook is to save dynamically the data including the invoice number , date, total price ..etc. extracted form the first workbook . At the end of the day I am going to save both workbooks and shut down the computer . what I would like to have the next day is when I open the first workbook , I want to open the second workbook using a command button on the first workbook , also I want to be able to get the last invoice number saved in the second workbook to be transferred to the first workbook with adding one to it . the invoice numbers are saved in column A2 :A in the second workbook. the invoice cell number is L11 in the first workbook .
I have created a command button on the first workbook to open the second workbook , that is successful , but I am not able to write the correct VBA code to transfer the last row cell value of column A from second workbook to the first workbook .
Can you please help me ?
thanks

hi, I would need such a thing with sumif. i have a list with duplicates and i need to group. Hope you can help me. thanks

Thank you so mutch

Hello, This was awesome. Exactly what i needed. Your work is absolute marvel!!!! Could you please assist on how i can do this for multiple columns without repeating the codes each time. Thanks!

how about i do have a first run for the consolidate for all worksheets into one worksheet. how am i going to sums everythings in my active worksheets

I am getting application defined or object-defined error on using this same code in the first line. Kindly help

need sumif sumifs countif countifs and pivot using vba please help me

That is awesome. Thank you. 👍

Well explained thanks

dear, you must clear your concepts first before uploading the videos

From Egypt
Thank you very very much

this helped a lot. thanks

Thanks for being very detailed in every move you made

part of your code is chopped off,..

congrats, great video

Thank you very much but if I want to sum 2 columns like this, what will the code be ?

It cant work for below codes. Anyone can help?
Sub ltd1()
lastrow = ActiveSheet.Cells(Rows.Count, 12).End(xlUp).Row
ActiveSheet.Range("l" & lastrow + 1) = Application.WorksheetFunction.Sum(ActiveSheet.Range("l2:l" & lastrow).Sum))
End Sub

Hey Buddy!! Thanks!! you do not know how difficult were to found a easy solution to the issue with the variable ranges, Thanks a lot.

Thanks, helped a lot.

Hi Daniel, what if I have a dynamic filter and I wanted to just get the sum of the filtered dataset? Please advise :) Thanks

Thanks for the tip. I have another question, using the same method  how would you do a subtotal after row change. Example say the first 10 rows in Column A say Mike, there would be a total after that in column B , then the next 7 say Dan this would total, etc.

Thanks Again for the tips

Thanks dude. Your Dropbox files are cool too. I used "SUBTOTAL in Bottom Cell using Excel VBA.xlsm". It's exactly what i needed.

i am having trouble with a very similar problem but mine is different in that i need to get the average of different size datasets in the same column so just like above the first dataset is so many rows long and you got the total of that now what i need to do i just insert a blank line and enter values for the next dataset and then get the average of that new dataset EXAMPLE DATASET1 4 5 5 5 6 6 AVERAGE ????? DATASET2 1 1 2 3 AVERAGE ???? ANY IDEAS ?

Real nice, thank you, may I ask for an example if there are blank cells in Column B please. Or possibly zeros in the empty cells but the cells with zeros do not have visible text (numbers), maybe something like that if empty cells are not possible. Thank you. Duane

You may be right. I generally do that when there are super lots of redundancies. Thanks for your comments, guru dude. Dan

looks good... you might want to try using "with" and "end with" to clean up the code a-bit ;)

Thank you sobolev!

Thanks for the tip.

Thanks a lot for this great effort Dan!