answersLogoWhite

0

SUM() is a function within Excel which adds up the values of the cells that are passed to it. You can pass individual cells, a list of cells or a range of cells. e.g.

=SUM(A1) returns the same value as the cell A1
=SUM(A1,B2) return the sum of A1 + B2
=SUM(A1:B2) returns the sum of the range A1:B2

Ranges are effective squares of cells, so the range A1:B2 is a small 2x2 square consisting of A1, A2, B1 and B2.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What following functions was new in Excel 2007 sum ifs sum if count if or sum?

SUMIFS was new in Excel 2007.


What do you use to sum a large range of data in Excel?

The SUM function.


What is the sum of 7 and 4 in Excel spreadsheet?

The sum of 7 and 4 is 11, whether in an Excel spreadsheet or anywhere else. In Excel the formula would be =SUM(4,7) or =4+7 or =(B12+B13) if the values 7 and 4 were in cells B12 and B13.


What is the sign of sum in Excel?

The representation of SUM is the capital Greek letter SIGMA (Σ).


What are some examples of Excel formulas?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)


When was Sum ifs introduced to Excel 2007?

The SUMIFS function first appeared in Excel 2007. The previous version, Excel 2003, did not have it.


How do you add 2 values in Excel?

The 'sum' function.Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.


Can you use Sum Function in school?

If you use Excel in school, then, yes, you can use the SUM function.


Give 5 functions of formulas in Excel?

Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX


What is the name of the button you click to sum cells in Excel?

You use the sum button in excel when you want to add numerous amounts of numbers.


What is the keyboard shortcut for the Auto-Sum feature on excel is?

Alt+=


How do you perform a quick-sum in Excel?

Quick-sum in Excel 1. Select the cells you want to sum (Hold CTRL key to select non-adjacent cells) 2. Right click the status bar and select SUM (This is the default option) 3. Now check out the sum of the numbers you selected in the status bar.