How to Calculate Summation in Same or Separate Sequence in Excel

Date:2019-12-4 Author:Olivia

If you need to calculate summation of numbers, let Excel do it for you. It might be easy when it’s in same sequence but a little bit difficult in separate sequence. So let’s take a look at the tip you can complete it in a simple way.

  • In Same Sequence

1. Drag to select numbers in same sequence, and here I choose the numbers that are in the same column as an example.

How to Calculate Summation in Same or Separate Sequence in Excel

2. Go to Home tab, find Editing group and click AutoSum.

How to Calculate Summation in Same or Separate Sequence in Excel

3. The summation in same sequence has been calculated automatically and will be displayed in the last.

How to Calculate Summation in Same or Separate Sequence in Excel

  • In Separate Sequence

1. Select a blank space which is close to the numbers in separate sequence.

How to Calculate Summation in Same or Separate Sequence in Excel

2. Go to Home tab, find Editing group and click AutoSum.

How to Calculate Summation in Same or Separate Sequence in Excel

3. Press [Ctrl] in keyboard and use the mouse to select numbers one by one.

How to Calculate Summation in Same or Separate Sequence in Excel

4. Press [Enter] in keyboard and the summation in separate sequence has been calculated automatically and will be displayed in the blank space.

How to Calculate Summation in Same or Separate Sequence in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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