Adding & Subtracting Vertical Columns in Excel : MS Excel Tips

Subscribe Now:

Watch More:

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.

[christinayannayon]

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

[jenniferlechic]

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

[kofiyeboah]

omg this is very precise and straight forward. I wish every instructor on YouTube 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.

[gaylaowen]

Tried several other videos - grateful to find yours - straightforward, easy to understand!

[andrewblankenship]

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?

[AnizJ]

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

[zendean]

By the way this video is about adding and subtracting HORIZONTALLY not vertically. He is vertically filling but the actuall adding is horizontal.

[ciarancronin]

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

[rpugkox]

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

[paulwyse]

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

[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

[normanandy]

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

[heatherthomsen]

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

[odaversa]

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

[CarlosRamirez-osts]

MY BOY TED COMING IN CLUTCH TODAY!!! 2FOR2!!!

[joebyron]

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

[darkprincess]

Thank you for that simple explanation.

[umaturrehman]

Amzaing.. explained in very simple and accurate way

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