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

  Рет қаралды 5,204,607

eHowTech

eHowTech

Күн бұрын

Пікірлер: 807
@KashikaDhingra
@KashikaDhingra 4 жыл бұрын
thanks sm !! you’re still helping ppl 7 years later 😂😂
@SoundzOfficial
@SoundzOfficial 3 жыл бұрын
Def😂😂
@stelakem
@stelakem 3 жыл бұрын
I know right? 🤣🤣🤣
@tiktokhall4336
@tiktokhall4336 3 жыл бұрын
8 years for me😂😂
@wilsonjoshua6209
@wilsonjoshua6209 3 жыл бұрын
8 years later 😂
@hanabunga7605
@hanabunga7605 3 жыл бұрын
Yeahhh in 2022 😂😂🤚🏻✨
@KandB2012
@KandB2012 Жыл бұрын
1 minute in and you saved me hours!!!! Thank you
@masterabdulhaq7638
@masterabdulhaq7638 9 жыл бұрын
KZbin IS ONE OF MY BEST TEACHER AND FRIEND THANKS A LOT
@Walking-with-time
@Walking-with-time 3 ай бұрын
who is watching in 2025
@farusky629
@farusky629 3 ай бұрын
We're here👋
@Wind_Pictur1ng
@Wind_Pictur1ng 3 ай бұрын
Why hello there lol
@NobuhleMpinga
@NobuhleMpinga 2 ай бұрын
I'm here❤
@mohammadonagh7294
@mohammadonagh7294 2 ай бұрын
hehe
@RandomContentGags
@RandomContentGags Ай бұрын
Hey internet stranger
@abdiwahabahmed8144
@abdiwahabahmed8144 2 жыл бұрын
Thank u Mr Edward. U r helping us after 9 years.
@sazzadhussainsazz5299
@sazzadhussainsazz5299 2 жыл бұрын
Dude is helping people. No doubt.
@Apexkevin7
@Apexkevin7 4 жыл бұрын
I may be 7 years late, but thanks!
@ALEXIS-xu8jo
@ALEXIS-xu8jo 4 жыл бұрын
😂
@nicholasroger2907
@nicholasroger2907 4 жыл бұрын
Same
@sheilamanyorio5645
@sheilamanyorio5645 4 жыл бұрын
Me too lol
@garym3407
@garym3407 4 жыл бұрын
Better late than never!
@akhilakhil512
@akhilakhil512 3 жыл бұрын
@@ALEXIS-xu8jo 👍
@innocentd07
@innocentd07 7 ай бұрын
Thank you for uploading this video 11 years before I needed. Stay blessed 😇
@zmvila
@zmvila 6 жыл бұрын
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.
@pope08anto
@pope08anto 8 жыл бұрын
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
@johannsebastianbach9003 3 жыл бұрын
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
@reallyhimongod 5 ай бұрын
It doesn’t fuckin work stfu
@jujustukaisenisthebestyes
@jujustukaisenisthebestyes Жыл бұрын
Thanks u still helping people 10 y years later
@karlvan-gelder2634
@karlvan-gelder2634 2 жыл бұрын
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
@normaaliihminen722
@normaaliihminen722 2 жыл бұрын
Even though this is nearly 10 years old, this video still is USEFUL!
@ambrooks5
@ambrooks5 3 жыл бұрын
I use to be fairly decent with Excel but it’s been a few years. Easy and straightforward. Thanks!
@badapborkatrai4166
@badapborkatrai4166 5 жыл бұрын
I had data entry job exams tomorrow. This is helpful. Thanks.
@EssenceHove
@EssenceHove 3 ай бұрын
Well-done Muku ...I don't usually listen to your songs but on this you earned my respect
@FluffskiYT
@FluffskiYT 2 жыл бұрын
Thanks for the help. I went on an excel course through my employer but still this video explains things so much better
@melissahankla8303
@melissahankla8303 Жыл бұрын
This is pretty much the only time I didn’t have to search for a different video. Thank you so much.
@Ronnie_D25
@Ronnie_D25 2 жыл бұрын
Perfect, to the point, and specific.... been searching all day for a video like this.
@haroldsaalfeld7199
@haroldsaalfeld7199 Жыл бұрын
Clearly conveyed information on how to add columns. I am a novice at excel. Thank you so much.
@fufularue3627
@fufularue3627 8 жыл бұрын
Whew! Short, sweet, and to the point without a lot of blathering. Thanks!
@PaulPhiri-pw4xz
@PaulPhiri-pw4xz 8 ай бұрын
This is amazing. Continue helping people with these skills.
@oliviamcclain4436
@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
@user-hv8bo4ie2v
@user-hv8bo4ie2v Жыл бұрын
i am taking an Excel course and this is helping so much. Thank you!
@4x4American
@4x4American Жыл бұрын
Thanks! Took an excel class years ago, but forgot everything, now I need, fast and easy, thanks!
@tensaichigo2
@tensaichigo2 2 жыл бұрын
MAN LIKE TED! Just saved my bacon! Thanks for simple and easy explanation. Much appreciated. 👍🏾
@melissafrances2038
@melissafrances2038 7 жыл бұрын
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!!
@pearlin.1566
@pearlin.1566 9 ай бұрын
Damn you’re helping the kid 11 years later
@myvillagefolk924
@myvillagefolk924 3 жыл бұрын
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.... 🙏
@chrisfreeman1991
@chrisfreeman1991 2 жыл бұрын
This was exactly what I was looking for. Video was clear and precise!
@kimberlymendez9834
@kimberlymendez9834 3 жыл бұрын
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.
@itruck1
@itruck1 3 жыл бұрын
When you say hit "return" what key are you talking about? I don't see anything on my laptop that says "Return".
@ShaniGreeneDowdell
@ShaniGreeneDowdell 3 жыл бұрын
Enter Key
@savood1982
@savood1982 2 жыл бұрын
Thankx sir … still help after 9 years👏👏👏
@Shisir7424
@Shisir7424 Жыл бұрын
Wow, just awesome bro...🥰🥰♥️♥️🥰🥰
@Bs62025
@Bs62025 2 жыл бұрын
Sir you are helping people still 9 years
@stevenf.1291
@stevenf.1291 2 жыл бұрын
I know absolutely nothing about Excel. But this was very easy to understand. Thanks
@Smiley-jk6wm
@Smiley-jk6wm 9 ай бұрын
Thank you for taking the time to upload your video. It was beneficial.
@mthobisiminathi1413
@mthobisiminathi1413 Жыл бұрын
It been 10 years since this video was uploaded and I have found this very impressive and informative, thank you Ted.🔥🙏🏽
@WHU448
@WHU448 4 жыл бұрын
I always said that KZbin should promote more DYI and educational videos rather than time-wasting entertaining videos. This video deserves my thumbs up! (👍🏽)
@lealea5702
@lealea5702 Жыл бұрын
What a time saver! Thank you.
@catkin1628
@catkin1628 3 жыл бұрын
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.
@JAYBZWRLD
@JAYBZWRLD Жыл бұрын
Still helping people 10yrs later thank you🤣🤣
@methodfortytwo4308
@methodfortytwo4308 2 жыл бұрын
9 yrs and still helping out folks😇.. Thanks
@CidyAcosta-r3l
@CidyAcosta-r3l Жыл бұрын
I love it. Very short and concise . Easy to understand
@sharronhagen8442
@sharronhagen8442 7 ай бұрын
Many thanks - a very clear demonstration.
@danieloladimejiogunniran7380
@danieloladimejiogunniran7380 4 ай бұрын
Very helpful. Thank you for simplicity
@jeniferkpundeh8679
@jeniferkpundeh8679 2 жыл бұрын
I’m just getting started 🤞🏼🤞🏼🤞🏼can’t wait to dive into......
@michellephillips-trademan1466
@michellephillips-trademan1466 6 жыл бұрын
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
@azamsyed8827 4 жыл бұрын
kzbin.info/www/bejne/npupZ6uJgdCnjrM
@jodileben694
@jodileben694 4 жыл бұрын
I've never used excel before and I'll need to for college, so thank you, 7 years late! ;)
@sumantapanda1061
@sumantapanda1061 3 жыл бұрын
Tnx u are helping after 8 years
@Anachava2002
@Anachava2002 Жыл бұрын
Thank you!!!!!!! 10 years later and I’m so happy this video is here 😢
@shesheme24
@shesheme24 10 ай бұрын
Thank you so much. I am just starting to learn Excel.
@sheldonbailey8857
@sheldonbailey8857 2 жыл бұрын
Really appreciate learning from you. Thanks!
@NationwideTrailers
@NationwideTrailers 2 жыл бұрын
What about adding cells from multiple sheets?
@ThegreatBoso
@ThegreatBoso 2 жыл бұрын
You are the best. I come here every year when I am filing my taxes. Thank you for doing a great video that will stand the test of time.
@Jahcrooks
@Jahcrooks 2 жыл бұрын
Do you have to have digits in the cell for this to work?
@alexxdaye1
@alexxdaye1 2 жыл бұрын
You just made life sooooooo much easier! Very helpful, thanks a million! You just gave me years back on my life.....really! 😂🙌🏾
@AlanVickers1992
@AlanVickers1992 3 жыл бұрын
Cheers for this, somehow forgot everything I learned from using excel back in the day.
@edpropst547
@edpropst547 10 ай бұрын
Thank you. Short and to the point.
@rs_0533
@rs_0533 Жыл бұрын
Saved a life mate thanks
@Drews80
@Drews80 3 жыл бұрын
i may be 8 years late but thanks
@ldysc
@ldysc 4 жыл бұрын
THANK YOU SO MUCHH! I understand much better here than my teacher in school thanks a lot sir!!!!
@Ecks520
@Ecks520 6 жыл бұрын
Sigmund is killing it!
@mariaserra9440
@mariaserra9440 3 жыл бұрын
Thank you, it explained it very well
@LivingWithTheGuzmans
@LivingWithTheGuzmans 5 жыл бұрын
Thank you
@nitwaalebhaiya
@nitwaalebhaiya 3 жыл бұрын
Thanks. You saved a lot of my time.
@dopsmaintenance5825
@dopsmaintenance5825 Жыл бұрын
Thank you very much. Still helpful years later
@delowerkhan442
@delowerkhan442 8 ай бұрын
Thank you helping ppl still using it 11 years latter my daughter turned 11 on 12 of may
@trishschmidt8530
@trishschmidt8530 7 жыл бұрын
This man is the best teacher for excel!
@Stahlkorps101
@Stahlkorps101 7 жыл бұрын
It's easy when you've got someone to show you how. Thankyou!
@khern9998
@khern9998 2 жыл бұрын
Omg thank you! I finally got how to do the formulas.
@MercyMwala-h6r
@MercyMwala-h6r Жыл бұрын
Thanks 😊 still helpful
@barbpitkin6935
@barbpitkin6935 6 жыл бұрын
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?
@frankmoyer4519
@frankmoyer4519 3 жыл бұрын
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
@msg5977
@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!
@zf8496
@zf8496 2 жыл бұрын
Much much appreciated you made my job easier because didn't use Excel since 2004! LOL
@kallachnadra
@kallachnadra 2 жыл бұрын
Thanks a lot. Easy and simple clarification. I was looking some other youtubers...(Indian-greeders)..who justwants me to roll on their course. This is getting too much commerical.
@wonderwomen7673
@wonderwomen7673 4 жыл бұрын
this tip has helped me so much, it's going to save me hours of work. bless you.
@benissan1
@benissan1 Ай бұрын
What do you mean by head the return are mean enter? Thanks
@Amie-Tube
@Amie-Tube 2 жыл бұрын
Thanks for your tutorials!
@RobertMack-iz7yi
@RobertMack-iz7yi 11 ай бұрын
VERY HELPFUL, Sir - many many thanks!!
@larm4u
@larm4u 4 жыл бұрын
Who would give this video a thumbs down? I gave a thumbs up, it was great. If you didn't think it was great, no problem, but to give a thumbs down, how much do you need to hate yourself to give this a thumbs down?
@Chicgirlie
@Chicgirlie Жыл бұрын
How do you calculate the SUM across a column if you have blank spaces in the dataset?
@Kunwar95
@Kunwar95 5 жыл бұрын
What is the formula to keep adding to current sale and result should show in same sale? Like if my mtd sale is 10000 and todays sale is 1000 , it should be adding in same cell where 10000 is there result should be 11000 in same cell. For example till yesterday my total sale showing 10000 n when i enter daily sale as 1000 in daily sales column then it should show total sale till today as 11000 in same cell. Plz help
@ninsiimaronald6458
@ninsiimaronald6458 Жыл бұрын
THAT WAS AWESOME, thank you so much Ted
@ayse-umitonder
@ayse-umitonder 2 жыл бұрын
just What I was looking for.Thank you 👌
@shuri
@shuri 2 жыл бұрын
Thank you for the simple tutorial.
@ThoughtSignal
@ThoughtSignal 3 жыл бұрын
Thanks alot Ted! im just getting started with excel.
@Irfanrabbani
@Irfanrabbani 5 жыл бұрын
Excellent short demo. Thx.
@nelisiwengubo2937
@nelisiwengubo2937 3 жыл бұрын
Very helpful!👍 Am using it for my school project!✔️💯🇿🇦
@fast-infoglobal7836
@fast-infoglobal7836 6 жыл бұрын
JUST SO SIMPLE AND NICE I GOT WHAT I NEEDED IMMEDIATELY THANKS AND MAKE MORE FROM DUBAI
@patelvidhu4840
@patelvidhu4840 6 жыл бұрын
You explain it in most easy way. Thanks.
@VISHNUKUMAR-sw1dh
@VISHNUKUMAR-sw1dh 2 жыл бұрын
I tried so many times how to figure out the sum easily without any guidance but I couldn't do that. Finally, I passed into your video I easily made it. Thank you very much, sir,
@djjohnyg
@djjohnyg Жыл бұрын
Thank you Ted! 👍
@soumiamoujane3695
@soumiamoujane3695 3 жыл бұрын
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =( SUM(D6:D38 in the total box and click enter
@MoreTeeVicar1
@MoreTeeVicar1 10 жыл бұрын
Thanks - Such an easy way. I had this question during a job interview and I got completely muddled up. Wish I found your tutorial beforehand!
@choco143able
@choco143able Жыл бұрын
Superb explanation 🎉
@rosesiddiqi2308
@rosesiddiqi2308 2 жыл бұрын
Thank you so much from 8 years in the future! 😄
@sarahshahid9295
@sarahshahid9295 2 жыл бұрын
It was a real big help. Thank you I was able to learn from your video in a minute it’s so easy to follow.
@amrmostafa16
@amrmostafa16 3 жыл бұрын
Thank you Ted, this was very helpful
Excel Formulas and Functions Tutorial
12:29
Kevin Stratvert
Рет қаралды 3,4 МЛН
Spreadsheets #1: Introduction
13:27
ExplainingComputers
Рет қаралды 1,1 МЛН
Жездуха 42-серия
29:26
Million Show
Рет қаралды 2,6 МЛН
Sigma girl VS Sigma Error girl 2  #shorts #sigma
0:27
Jin and Hattie
Рет қаралды 124 МЛН
24 Часа в БОУЛИНГЕ !
27:03
A4
Рет қаралды 7 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
How To Do Basic Math In Excel (Add, Subtract, Multiply, Divide)
3:46
Steven Bradburn
Рет қаралды 297 М.
MS Excel - Student Mark Sheet Calculation   Sum, Average, Rank, Grade, Pass Fail, Status
11:16
Vedanta Courses • 1M Views • 1hr ago
Рет қаралды 1,9 МЛН
How to Sum a Column in Excel
2:10
Excel Tutorials by EasyClick Academy
Рет қаралды 1,1 МЛН
Advanced Excel - Data Validation and Drop-Down Lists
13:08
Technology for Teachers and Students
Рет қаралды 1,9 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 287 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 8 МЛН
Intermediate Excel Skills, Tips, and Tricks Tutorial
20:18
Technology for Teachers and Students
Рет қаралды 6 МЛН
Excel SUM and SUMIF Formula in Excel
7:53
Kevin Stratvert
Рет қаралды 360 М.
Жездуха 42-серия
29:26
Million Show
Рет қаралды 2,6 МЛН