How to Make a Totaling Column Formula in Excel : Using Microsoft Excel

[@KashikaDhingra]

thanks sm !! you’re still helping ppl 7 years later 😂😂

[@SoundzOfficial]

Def😂😂

[@stelakem]

I know right? 🤣🤣🤣

[@tiktokhall4336]

8 years for me😂😂

[@wilsonjoshua6209]

8 years later 😂

[@hanabunga7605]

Yeahhh in 2022 😂😂🤚🏻✨

[@Apexkevin7]

I may be 7 years late, but thanks!

[@ALEXIS-xu8jo]

😂

[@nicholasroger2907]

Same

[@sheilamanyorio5645]

Me too lol

[@garym3407]

Better late than never!

[@akhilakhil512]

@@ALEXIS-xu8jo 👍

[@KandB2012]

1 minute in and you saved me hours!!!! Thank you

[@Walking-with-time]

who is watching in 2025

[@farusky629]

We're here👋

[@Wind_Pictur1ng]

Why hello there lol

[@NobuhleMpinga]

I'm here❤

[@mohammadonagh7294]

hehe

[@RandomContentGags]

Hey internet stranger

[@masterabdulhaq7638]

UA-cam IS ONE OF MY BEST TEACHER AND FRIEND
THANKS A LOT

[@abdiwahabahmed8144]

Thank u Mr Edward. U r helping us after 9 years.

[@sazzadhussainsazz5299]

Dude is helping people. No doubt.

[@innocentd07]

Thank you for uploading this video 11 years before I needed. Stay blessed 😇

[@M_Faraday]

Thanks for this! What do I do if the values are prefixed by a "$", and I want to add them together? =SUM doesn't seem to work with that.

[@nycollassilva3558]

Ggket

[@brothadre76]

I think u use SUBTOTAL, but I can't get it to work either

[@pope08anto]

I literally spent hours trying to do a simple summation of the column! After watching your video in less than 30 seconds I was able to do actually add up the column. Thank you sooooooo much for your video. Clear and simple. You are a lifesaver.

[@johannsebastianbach9003]

Lmao, xame here trying to figure it out without any help, but i kind of got frustrated and said fck it im watching youtube tutorials 😂😂😂

[@reallyhimongod]

It doesn’t fuckin work stfu

[@jujustukaisenisthebestyes]

Thanks u still helping people 10 y years later

[@melissahankla8303]

This is pretty much the only time I didn’t have to search for a different video. Thank you so much.

[@chrisfreeman1991]

This was exactly what I was looking for. Video was clear and precise!

[@Shisir7424]

Wow, just awesome bro...🥰🥰♥️♥️🥰🥰

[@ambrooks5]

I use to be fairly decent with Excel but it’s been a few years. Easy and straightforward. Thanks!

[@Ronnie_D25]

Perfect, to the point, and specific.... been searching all day for a video like this.

[@normaaliihminen722]

Even though this is nearly 10 years old, this video still is USEFUL!

[@karlvan-gelder2634]

omg i cant thank you enough. I have been trying to get my head around formulas for absolutely ages and this has really helped me. Thank you and im lookingh through at your other videos now to learn more. Thank you

[@EssenceHove]

Well-done Muku ...I don't usually listen to your songs but on this you earned my respect

[@zmvila]

this has been really help full as I am in a job away from home. I was required to use excel. I have not use excel since 2001 on my first year. you can imagine the street I had. until I open you video. thank you very much.

[@fufularue3627]

Whew! Short, sweet, and to the point without a lot of blathering. Thanks!

[@badapborkatrai4166]

I had data entry job exams tomorrow. This is helpful. Thanks.

[@melissafrances2038]

Thank you so much, Ted! I would have been doing my financial spreadsheet on Excel years ago if I had known it was so easy. You explained it in a way that I could understand. Thanks!!

[@tensaichigo2]

MAN LIKE TED! Just saved my bacon! Thanks for simple and easy explanation. Much appreciated. 👍🏾

[@Drews80]

i may be 8 years late but thanks

[@djjohnyg]

Thank you Ted! 👍

[@PaulPhiri-pw4xz]

This is amazing. Continue helping people with these skills.

[@MercyMwala-h6r]

Thanks 😊 still helpful

[@4x4American]

Thanks! Took an excel class years ago, but forgot everything, now I need, fast and easy, thanks!

[@oliviamcclain4436]

Thank you so much for the simple Shortcuts. I really like that you speak very clearly and not too fast or too slow for that fact. I will be watching more of your videos. I hope you are still putting out more videos. Thank you

[@LivingWithTheGuzmans]

Thank you

[@FluffskiYT]

Thanks for the help. I went on an excel course through my employer but still this video explains things so much better

[@Smiley-jk6wm]

Thank you for taking the time to upload your video. It was beneficial.

[@kimberlymendez9834]

Thank you. I’m taking a class and the assignment had 32 rows in a word document. I copied and pasted into excel. You just saved me hours of manually doing this.

[@ebonyrenee3296]

Thank you!

[@macXdim]

Hello! I did this formula but it always sum up to 0.

[@haroldsaalfeld7199]

Clearly conveyed information on how to add columns. I am a novice at excel. Thank you so much.

[@itruck1]

When you say hit "return" what key are you talking about? I don't see anything on my laptop that says "Return".

[@ShaniGreeneDowdell]

Enter Key

[@ayse-umitonder]

just What I was looking for.Thank you 👌

[@user-hv8bo4ie2v]

i am taking an Excel course and this is helping so much. Thank you!

[@myvillagefolk924]

Tnq very much sir 🙏
I am from India...🇮🇳
Yr videos are very helpful to me
in my office work...!!!
After searching of yr videos...
I felt very happy... as there is no need to ask anybody to do my excel sheet...!!!!
Sir... really I obey for you.... 🙏

[@Amie-Tube]

Thanks for your tutorials!

[@michellephillips-trademan1466]

This was MUCH quicker & easier than I thought it would be! Thanks a million for saving me so much time & keeping it so simple!

[@azamsyed8827]

ua-cam.com/video/hjF6xSLktXQ/v-deo.html

[@lealea5702]

What a time saver! Thank you.

[@barbpitkin6935]

hi good info but i have a total column that i want to have a formula that calculates subtraction from 1 column and addition from another column as i add information to those columns, I have my checking account on a spreadsheet and want to make it easier to add or subtract as i add debits or credits. can you help?

[@msg5977]

This was so helpful. You helped solve the problem I had--I had a blank line. Thanks so much for also making it easy to understand!

[@khern9998]

Omg thank you! I finally got how to do the formulas.

[@pearlin.1566]

Damn you’re helping the kid 11 years later

[@catkin1628]

Is there a work around if you have a blank column. I have a complex worksheet with macro and micro nutrients, I thought it was adding but on closer inspection not all of it . I've done a work around by adding 0.01in the gaps but this is not satisfactory and most food sources do not have all the macro and micro nutrients. Please Help. Thank you.

[@sharronhagen8442]

Many thanks - a very clear demonstration.

[@danieloladimejiogunniran7380]

Very helpful. Thank you for simplicity

[@Jahcrooks]

Do you have to have digits in the cell for this to work?

[@benissan1]

What do you mean by head the return are mean enter? Thanks

[@rs_0533]

Saved a life mate thanks

[@sheldonbailey8857]

Really appreciate learning from you. Thanks!

[@ninsiimaronald6458]

THAT WAS AWESOME, thank you so much Ted

[@savood1982]

Thankx sir … still help after 9 years👏👏👏

[@JT-616]

Thanks Awesome explaining in detail. keep up the great work. JT

[@Irfanrabbani]

Excellent short demo. Thx.

[@HunterKiss]

Thanks, was searching for this.

[@jeffersk]

Excellent👏

[@happynewt2359]

I know I'm late, but using your example, what if I were to hire a new employee? Is there a way of adding the new employee without having to delete the "total" row that you created?

[@frankmoyer4519]

OK so what if I want to add up the totals of the columns and totals across the rows than have a total box in the bottom right for a total of the bottom rows an dteh total of the columns as a check an dbalance

[@RobertMack-iz7yi]

VERY HELPFUL, Sir - many many thanks!!

[@mariaserra9440]

Thank you, it explained it very well

[@stephenshoobert5272]

This is great Ted. Thank you so much

[@amrmostafa16]

Thank you Ted, this was very helpful

[@mthobisiminathi1413]

It been 10 years since this video was uploaded and I have found this very impressive and informative, thank you Ted.🔥🙏🏽

[@Bs62025]

Sir you are helping people still 9 years

[@sumantapanda1061]

Tnx u are helping after 8 years

[@CidyAcosta-r3l]

I love it. Very short and concise . Easy to understand

[@alexxdaye1]

You just made life sooooooo much easier! Very helpful, thanks a million! You just gave me years back on my life.....really! 😂🙌🏾

[@wernerbezuidenhout9532]

Thank you Ted! Awesome! 👏👏👏

[@edpropst547]

Thank you. Short and to the point.

[@ThoughtSignal]

Thanks alot Ted! im just getting started with excel.

[@jodileben694]

I've never used excel before and I'll need to for college, so thank you, 7 years late! ;)

[@pandamyfb186]

greetings. wonderful video. thank you.
if I may ask how do you display which hours/week that if you input a certain number example 170 it will show which person and hours/week being displayed. example 170=(sigmund)80+(alex)45+(alexie)45
or any other methods that will be easier. thanks in advance

[@DawudIhsan-mt9vn]

Needed that😍 Thank you

[@NationwideTrailers]

What about adding cells from multiple sheets?

[@nitwaalebhaiya]

Thanks. You saved a lot of my time.

[@edba1591]

Exactly what I needed, thank you!

[@JAYBZWRLD]

Still helping people 10yrs later thank you🤣🤣

[@tyneshiajames1329]

Thank you, Sir. This was very helpful 🙏🏽✨️👍🏽👌🏽

[@stevenf.1291]

I know absolutely nothing about Excel. But this was very easy to understand. Thanks

[@bmed8363]

Wow, thank you for this!😊

[@amylanier5045]

Very Helpful! Thank You!

[@barbarapalmer1595]

Too easy, thanks Ted. Ready for the next lesson😂

[@Chicgirlie]

How do you calculate the SUM across a column if you have blank spaces in the dataset?

[@humble716]

This was very informative... Thank you

[@derekharold1208]

Brilliant Ted, many thanks.

[@choco143able]

Superb explanation 🎉

[@patelvidhu4840]

You explain it in most easy way. Thanks.

[@WHU448]

I always said that UA-cam should promote more DYI and educational videos rather than time-wasting entertaining videos.
This video deserves my thumbs up! (👍🏽)

[@jeniferkpundeh8679]

I’m just getting started 🤞🏼🤞🏼🤞🏼can’t wait to dive into......

[@shesheme24]

Thank you so much. I am just starting to learn Excel.

[@Chesripho]

Thanks Tom🎉

[@nanxyalba2352]

Thanks for uploading this video.

[@xNachtmahRx]

Hey is there a solution for when we want to use pivot tables? I have 150 attestations but the table chart shows a total of 11k and i can't find out why

[@Maximilian4812]

Thank you! It was a big help. 🙂

[@artverocruz]

you're the best Ted!