How to Add All the Sums into an Excel Table in a Second

You do it all the time: You create a table in Excel and add the sums in all directions. Below I will show you how to sum up all the values into an Excel table in just a second:

Select all the values in the table plus one extra column and one extra row for the sums:


EasyExcel_7_1

Press Alt + Equal sign (=), and Excel adds all the sums:

EasyExcel_7_2


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Clip to Evernote

One thought on “How to Add All the Sums into an Excel Table in a Second

Leave a Reply

Your email address will not be published. Required fields are marked *


5 − one =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>