Menu
EXCEL SUM FUNCTION
Excel SUM Function Introduction
The sum formula is one of Excel’s most basic and often used formulas. It’s used to calculate the sum of a cell range or ranges of cells.
Description of Excel SUM Function
Syntax:
=SUM(number1,[number2],…)
Parameter list:
- number1 is the first number you’d want to include.
- number2 – [Optional] – the second number to be added. This method allows you to provide up to 255 extra integers.
Step By Step Guide of SUM Function
Key Points
- Double quote marks (“) will be used to enclose any text or logical or mathematical symbols.
- Double quotation marks are not necessary if the criterion is numerical.
- In criterion, the wildcard characters? and * can be used. Any one is matched by a question mark.
- Any sequence of characters is matched by a character and an asterisk.
- If you want to use a question mark or an asterisk, enter a tilde () before the character, like this:?,*.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
