Adding & Subtracting Vertical Columns in Excel : MS Excel Tips
Ғылым және технология
Subscribe Now:
www.youtube.com...
Watch More:
/ ehowtech
Adding and subtracting vertical columns in Excel is something that you can do with specially designed formulas. Add and subtract vertical columns in Excel with help from a mechanical engineer in this free video clip.
Expert: Edward Russell
Filmmaker: Patrick Russell
Series Description: If you're looking for a very powerful spreadsheet application that works for both the Microsoft Windows and Mac OS X platforms, look no farther than Microsoft Excel. Learn more about Microsoft Excel with help from a mechanical engineer in this free video series.
Пікірлер: 205
You easily accomplished what other web sites failed to do with all their articles and illustrations. THANK YOU!
EXTREMELY USEFUL! EXACTLY what I was looking for on KZread. Such a quick and easy explanation! I needed to know how to copy and paste the formula down the whole column so I didn't have to retype the formula in each cell. Thanks so much!
omg this is very precise and straight forward. I wish every instructor on KZread will be this precise and simple.
Tried several other videos - grateful to find yours - straightforward, easy to understand!
THANK YOU!! You just saved me hours of pain. I greatly appreciate you taking the time to make and share this video.
Just 2 minutes I got what I have been looking for. Thank you
Omg thank you! Been searching all over the web for what should be an easy solution.
Thank you so much! This was quick, easy and very helpful. Much appreciated!
it may be an old video, but this saved me so much hassle! years since I looked at this stuff
you made it super easy and clear.
Thank you…straight to the point
ive been meaning to learn this, now i can keep track of face currency! thanks, ted!
Ted you are a god among pc nerds, you just saved me another hour or pissing about with this thing! Id figured the sum out easily but I could not figure out how to do it on every line at once. Thank you!!
MY BOY TED COMING IN CLUTCH TODAY!!! 2FOR2!!!
Thanks to KZread and you sir, I just got what I was looking for in a sec
Thank you so much is exactly what I was looking for !!!!and it didn't matter if it was HORIZONTALLY or VERTICALLY it was very helpful. :)
How do I add all the totals in Column x when each cell has different signs (+) (-), example = (L2 + L40) but cell 4 might be $125.00 and cell 8 is - $200, i want to get the total sum watching signs of course so we get the Profit or Loss total on row L41?
This is the best answer to another question I was seeking an answer to: how to add ONLY the contents of some, selected, columns and not others, and I loved the pull down example too to activate the same addition formula for all rows. Very clear, you get it in seconds.....
Thank you Ted. I even used the knowledge for multiplication and division.
Very good delivery of training topic. Knowledgeable, professional, and courteous.
finally someone who knows his stuff
Thanks I’m new-ish to excel and needed the help!
thanks sir !!!! i m from INDIA,, its very helpful
By the way this video is about adding and subtracting HORIZONTALLY not vertically. He is vertically filling but the actuall adding is horizontal.
Very helpful for the fearful excel beginner😊. It has never been my favourite thing to learn how to do properly. Love how easy this is😊
it is really easy after you showed. very helpful!! Thank you!
Thank you for that simple explanation.
This helped me today, thanks!
Thank you sir, i was looking for the exact video you uploaded. It is really sad that I had to g through so many irrelevant videos to reach this video
Saves my bacon. Up until your video I was sitting here with a hand calculator subtracting my bookkeeping
Ted question, I want to add two cells in a row and minus from the third cell to the same row and answer on the fourth, please note I have the "IF" command in cells one and two same row. Please TED HELP!!!!
Thank you so much, finally something without blabber
Thank you Tedd. That's all I needed
Gotta appreciate u man in 2021 i am in keen need to this and i am able to complete now my Mtech thesis on time. thanks
EXTREMELY HELPFUL thank you Ted.
Excellent. Short and to the point
Easy to understand and worked perfectly for what I needed to do, first try! Thank you!
Thank you it helped in my accounting assigment
Thank goodness!! You just saved me hours!!!
Excellent video!
THANKS, it was really helpful
amazing! got my work done in no time!
Thanks you save me lot of time
Very simply explained. Thnx a million
Thank you for the information very helpful for the beginner.
Thank you, Ted!!
Amzaing.. explained in very simple and accurate way
Thanks Ted!
I just came back to revisit this video, and after thinking about it for a couple of months I affirm that this video is STILL about adding HORIZONTAL ROWS not VERTICAL COLUMNS. I think this guy needs to use a dictionary. You see, vertical goes up and down. What you show here is adding across horizontally. Please fix this so you can stop wasting people's time who want to know how to add vertically.
@HudsonREng
8 жыл бұрын
+Shawn Dean actually he taught how to do both.
@tonyi5849
7 жыл бұрын
Not really Hudson, if that was the case then the results of each vertical column would be added together, not one from each column horizontally. Did you see a result of adding an entire vertical column anywhere in this video?
@Essays4College
5 жыл бұрын
Also, it was the adding and subtracting of just 2 cells. What if you were adding and subtracting a range? That's what most people will need to do.
@Incognit0777
5 жыл бұрын
@@Essays4College True. For that you need the SUM formula. It will look something like this (with the respective cell names, of course): *=SUM(Mark all the cells you need to subtract from) - SUM(all the cells you are subtracting)* For example:
Thank you Ted 👏👏👏
Wow. It helped me within seconds.
It seems to me that you are adding/subtracting cells, not columns. What if I wanted to add two columns, subtract another one and have the result in a single separate cell? Does anyone know the answer for this? Thanks.
Thank you Ted!!
thank you Sir for sharing your knowledge ! please do more and make it as simple as this video.
Thank you Ted. I am wondering how to subtract a value in C25 - D5 but can't seem to do it.
Thank you! This was clear and helpful. Appreciate your taking the time to help out others!
very helpful sir. thanks a lot
You sir are a genius. lol Thanks
Thank you. Helped me with the simple work that I had no idea how to do.
Ted, how do you get the same results but with only using a total for one cell in Column C instead of corresponding cells for a complete total.
Does anyone know to multiple what you subtracted in the same cell for example if I put =AA2-J2 gives me 5 but how do I multiple that 5 with another cell which could be Q2 that’s 2. I tried to do this first but I gave a calculation that was wrong =AA2-J2*Q2. But doing this it gives a complete wrong answer to what I want which I’m sure I’m just calculating this in excel incorrectly. How do you multiply in the same cell what you just subtracted
Thank you Ted! You made it soooo simple. I just like how short and simple you explained it. I will appreciate more tips. Since I am learning the program on my own. Thanks again.
Thanks! That such a simple things as adding a - to subtract numbers should be that hard. Thanks uploader!
Very helpful thanks
Thanks, very helpful; exactly what i was looking for
Thanks very helpful👍
This video so interesting 😅 and very easy editing video for me
Thank you, i learned Quick and easy ^^.
thx this was really helpful!
Really helpful sir thanks
I was stuck on how to subtract horizontally, thank you for the video!
Thanks uncle !!
Thanks for helping me...
But when the column is extremely long, it is not time efficient to drag. What is the better way to apply summation to the long column?
Thanks, it was easy
How do I add cell G1 all the way up to G109? What is the return button?
"hi i'm Ted" LOOOOOOOOOOOOOOOOOL hello Teddy
Thank you ! Quick and easy to follow ! Appreciate your sharing your time.
Many thanks 😊
thank you Ted
Thank you for this video. It is so easy to do. You saved me a crazy amount of time.
Thank you so much Sir
Thank you!
Thanks Ted👍
thanku..You saved me up..Thanku Thanku.
Thank you very much.
Thank you sir!!
This is so much helpful to me , thanks ji .
I appreciate. Very useful
EXACTLY what I needed to know. Thanks a million!
Thanks Ted
OMG THANK YOU SO MUCH
Thank you from Malaysia. It's absolutely helpful! :)
Thank you teaching !
its really easy way. thanks!
You just saved my day.. Thanks..
Thanks Ted very helpful!
Thank you!!
Thanks for sharing - Yes ok in almost all of the YT videos they only show Column A and B, but what if you have more data such like in A (Main Amount) and wish to subtract the data from cells, B, C, D, E, F for example....
Thank you so much