Microsoft Excel: Quick Sum a Data Range - AdvantEdge Training & Consulting

Microsoft Excel: Quick Sum a Data Range

You can quickly sum a block of data (both Rows and Columns) in Excel with just one click.

    • Start by selecting the data including the cells that will contain the SUM Formulas. (in our example Column E and Row 11)

Excel Data Range

    • On the Home Tab in the Editing Section, click the SUM button.
    • Excel will create a SUM function for each Row and Column.

Excel Data Range quick sum

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top