How to Use SUM Function in Microsoft Excel with Examples

In this tutorial we will discuss, how to us SUM Function in Microsoft Excel. SUM Function is a  most important and useful formula in Excel. Adds all the numbers in a range of cells.

How to Use SUM Function in Microsoft Excel with Examples

Syntax:

SUM(number1,number2, …)

The SUM function can take up to 255 arguments.

Examples:

=SUM(B3:17)

Sum Function example

Define Formula:

B3 =  First Value Cell Reference.

: Range of contiguous cells (for example, A1:C16)

B17  = Last Value Cell Reference.

The following formula, for example, returns the sum of the values in multiple ranges:

multi reng Sum function in excel

Horizontal range use in Sum Function:

The SUM function is versatile, but it’s also inconsistent when you use logical values (TRUE or FALSE). Logical values stored in cells are always treated as 0. But logical TRUE, when used as an argument in the SUM function, is treated as 1.

 

,

Leave a Reply

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