SUM Functions and Formulas in MS-Excel in 6 Best Ways

0 Comments

Sum Functions and Formulas in MS-Excel: In an excel spreadsheet, you can add number values in many different ways by using the pre-defined functions, user-defined formulas, or any other options in the ribbon. These are summarized below. 

Sum Function in MS-Excel in Several Ways:

Excel Function (Pre-defined): An excel sum function adds the selected numbers in a cell or a range of cells. The value can be number, cell reference (address), range, or array. If you select any other character/s besides numbers for addition, the sum function ignores without errors by adding the numeric value.

Sum Functions and Formulas in MS-ExcelSum Functions and Formulas in MS-Excel

SUM Functions and Formulas in MS-Excel

Syntax for Sum Function: 

=SUM(number, number2, number3…)

Or,

=SUM(first cell reference : last cell reference)

Example:

=SUM(A1:D1)

Method-1

=SUM(b2:b7)

In the above SUM function, b2:b7 is the range getting by selecting from the first cell reference b2 to the last cell reference b7.

Method-2

=SUM(b2:b7)

In the above SUM function, b2:b7 is the range. And each reference in a range is taken as given below.

B2 → It is the first cell reference getting by typing or selecting b2

:    →  Shift + ;

B7  → It is the last cell reference getting by clicking or typing b7

Method-3

Sum Function in Excel Using Range

=SUM(b2:b7)

In the above SUM function, b2:b7 is the range. And each reference in a range is taken as given below.

b2 → It is the first cell reference getting by selecting or typing b2

:b7 →  press and hold down “Shift + → or Shift + ↓”  (selecting the range till the last cell b7 is to be selected)

Method-4

Sum Function in Excel using Range:

=SUM(b2:b7)

In the above SUM function, b2:b7 is the range. And each reference in a range is taken as given below.

b2 → It is the first cell reference getting by selecting or typing b2

:b7 → Keep hold down the “Shift” key, and then click the last cell (b7).

Method-5

Auto Sum → Alt + =

=SUM(b2:b7) function is taken as describing below.

Auto Sum Function in Excel:

·        Select the range that you want to add the numbers, then press Alt + =.

(Or)

·        Select the range of cells that you want to ad its number value.

·        On the Home tab, in the Editing group, click the “AutoSum” command.

Methode-6

=sum(a3,b2:b7,d6)

Reference, Range, and Reference: In the above method, you can select the cell, range, then cell that contain numbers to ad as given below

·        a3                → select the cell that contain number.

·        b2:b7        → Select the range of cells that contain numbers.

·        d6             → select the cell that contain number.

Insert Sum Function in MS-Excel:

There are two ways to insert Sum function in excel, these are explained below.

  • Type the number value that you want to add, then click below the last number of your number list.
  • Click on the fx icon that appears right to the formula bar to open the insert function dialogue box.
  • Type the “Sum” to search for a function in the functions text box.
  •  Then click on “Go”, and then select the “Sum” as it is a function.
  • Now click on “OK” to open a insert function dialogue box.
Insert Sum Function in MS-Excel

Sum Functions and Formulas in MS-Excel:

  • Now select one-by-one number or select the range of cells that you want to add.
  • Lastly, click OK.

Sum Functions and Formulas in MS-Excel:

Sum Formulas in MS-Excel:

Excel Sum Formula (User-defined): An excel sum formula adds the entered or selected numbers in a cell or a range of cells. The value can be number, cell reference (address). If you select or enter any other character besides numeric value, it shows an error.

Formula-1

= 20+60+352+4+54+54

1.      Type an equal sign {=}

2.      Start entering the number value then enter the plus sign {+} between the numbers.

Formula-2

= f5+b1+c3+d1+n3

1.      Type an equal sign {=}

2.      Start selecting the cells that contain number then enter the plus sign {+} between the cell references.

Sum Functions and Formulas in MS-Excel in Several Ways

SUM Functions and Formulas in MS-Excel in 6 Best Ways

Sum Functions and Formulas in MS-Excel: In an excel spreadsheet, you can add number values in many different ways by using the pre-defined functions, user-defined formulas, or any other options in the ribbon. These are summarized below. 

Course Provider: Organization

Leave a Reply

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