Adding & Subtracting Vertical Columns in Excel : MS Excel Tips

Subscribe Now:
th-cam.com/users/subscription_c...
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.

[@jenniferlechic]

EXTREMELY USEFUL! EXACTLY what I was looking for on TH-cam. 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!

[@christinayannayon1974]

You easily accomplished what other web sites failed to do with all their articles and illustrations. THANK YOU!

[@AnizJ]

Just 2 minutes I got what I have been looking for. Thank you

[@kofiyeboah9939]

omg this is very precise and straight forward. I wish every instructor on TH-cam will be this precise and simple.

[@furstylist]

THANK YOU!! You just saved me hours of pain. I greatly appreciate you taking the time to make and share this video.

[@heatherthomsen6970]

Thank you so much! This was quick, easy and very helpful. Much appreciated!

[@joannezhou7959]

it is really easy after you showed. very helpful!! Thank you!

[@hollyhamilton1297]

Thank you Ted. I am wondering how to subtract a value in C25 - D5 but can't seem to do it.

[@mbambokazbalwa519]

Thanks to TH-cam and you sir, I just got what I was looking for in a sec

[@missfortune1123]

Thank you, i learned Quick and easy ^^.

[@chantaljones8170]

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😊

[@normanandy]

Omg thank you! Been searching all over the web for what should be an easy solution.

[@jpbounce]

Excellent. Short and to the point

[@anliesterhuyse3960]

Thanks, very helpful; exactly what i was looking for

[@user-rb9pr6rm2r]

EXTREMELY HELPFUL thank you Ted.

[@msqueenja6805]

Thank you…straight to the point

[@mariaypendergrass3974]

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. :)

[@zadramm1]

thank you Sir for sharing your knowledge !
please do more and make it as simple as this video.

[@dipdasadhikary579]

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

[@augustusb3501]

Excellent video!

[@andrewblankenship1973]

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?

[@ait__.sm__]

This helped me today, thanks!

[@darkprincess1918]

Thank you for that simple explanation.

[@bostonian1999]

you made it super easy and clear.

[@puppeteerdotbandcampdotcom]

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.....

[@paulwyse3837]

Thank you Ted. I even used the knowledge for multiplication and division.

[@marlonedubane4504]

Thank you for the information very helpful for the beginner.

[@greatre7r916]

Very simply explained. Thnx a million

[@RaghavsValueInvesting]

very helpful sir. thanks a lot

[@munsef_ali]

Very helpful
Thank you!

[@sirphilipobioha6997]

THANKS, it was really helpful

[@harryshenanigans3361]

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.

[@odaversa]

Very good delivery of training topic. Knowledgeable, professional, and courteous.

[@DelwinChowhan]

amazing! got my work done in no time!

[@zcarm]

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....

[@rahuljuneja1185]

Thank you teaching !

[@futuresavers9564]

Very helpful thanks

[@joebyron2984]

Thanks I’m new-ish to excel and needed the help!

[@joefrank1982]

Thanks Ted very helpful!

[@kyleferris388]

Thanks for this!

[@kittygailey5028]

Thank you! This was clear and helpful. Appreciate your taking the time to help out others!

[@badone3009]

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!!!!

[@PhoenixBlackthorn]

Easy to understand and worked perfectly for what I needed to do, first try! Thank you!

[@junqiyu3371]

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?

[@Gan8325]

Thank you Tedd. That's all I needed

[@thepeopleschoice5892]

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

[@valerietremblayblouin4271]

Thank you Ted!!

[@ciarancronin1575]

it may be an old video, but this saved me so much hassle! years since I looked at this stuff

[@rainschetchwazer8864]

thx this was really helpful!

[@haithambapeer8639]

Many thanks 😊

[@shivang1570]

Really helpful sir thanks

[@olajidealabi5671]

Great video. Thanks.

[@Emily-ps3ns]

Thank goodness!! You just saved me hours!!!

[@k4bu]

Thank you!

[@1313callum]

Thank you Ted 👏👏👏

[@hannicopter]

Thank you, Ted!!

[@NusratJahan-mm7fr]

its really easy way. thanks!

[@sudhirkulkarni6359]

I appreciate. Very useful

[@rheapeter9709]

Thank you sir!!

[@dehaati1056]

Very helpful and simple... ❤👍

[@babumanohar9093]

Thank you so much Sir

[@scoutintime]

ive been meaning to learn this, now i can keep track of face currency! thanks, ted!

[@vijaydubey3466]

Thank you!!

[@arjunrai3160]

Thank you it helped in my accounting assigment

[@lordfilluswithyourholyspirit]

Thank you very much.

[@user-rp4ug2ko6x]

thanks sir !!!! i m from INDIA,, its very helpful

[@SanjeevKumar-ly4sk]

This is so much helpful to me , thanks ji .

[@ranaamna9956]

Thanks, it was easy

[@umaturrehman5797]

Amzaing.. explained in very simple and accurate way

[@kotteeswaripanneer8600]

Thank you so much

[@antoniomahre9661]

You just saved my day.. Thanks..

[@rogersmith6234]

Thanks you save me lot of time

[@rahimparvez5410]

Thank you sir

[@ayaalsalihi6001]

Thanks
For this

[@charntsabre3463]

How do I add cell G1 all the way up to G109? What is the return button?

[@jessicalee347]

Thanks Ted!

[@Aprilwindz]

your a lifesaver :)

[@cagroot1]

Thanks Ted!!!

[@chrisjennings5047]

Thanks Ted👍

[@huilingphua4817]

OMG THANK YOU SO MUCH

[@mohammadhussien8044]

my respect sir ,thank you

[@shopnomoybalok3952]

Thanks a lot

[@akarshpr7336]

THANK YOU

[@omarlimousinetaxiservices4307]

Thank you

[@claireferreira5876]

thank u so much man

[@michaelsami6409]

thank you dude

[@RGhere.]

Thanks 😊👍🏻

[@digital_era4069]

Wow. It helped me within seconds.

[@jangoshe]

Thanks a lot!!

[@rajaryannayak]

Thank You

[@evobby502]

thank you !

[@anntarefin3637]

Thanks for helping me...

[@amandaragonjan2828]

So helpful

[@Wreckemrage]

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!!

[@raullopez1958]

Thanks man

[@selfsky3684]

Thank you :)

[@maxbinary]

Thanks ted!

[@remi2268]

thanku..You saved me up..Thanku Thanku.

[@carlmaslow1870]

Thanks a lot..

[@swekiwi4517]

Thanks! That such a simple things as adding a - to subtract numbers should be that hard.
Thanks uploader!