answersLogoWhite

0

The best way is to use the SUM function. If the block of cells you wanted to add were all the cells from A2 to C10, then you would type this:

=SUM(A2:C10)

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How many cells in a 2007 Excel sheet?

17,179,869,184 cells in one excel


Why are excel absolute ranges called ranges?

A range is a group or block of selection of cells. The term range can in ordinary language mean a group of things, or something going from one point to another, which a block of cells does. It is a group of cells and it has a starting and ending point, which would be the top-left and bottom-right cells.


What are the two kinds of columns in Excel?

Excel has only one type of column -- a vertical stack of cells.


How do you change multiple hyperlinks in Excel worksheet?

Hyperlinks can only be changed one at a time. You can select a range of cells and apply the same link to all of them, even without text in them. Select the cell or cells and press Ctrl - K to open the dialog box. You cannot put different links into the cells at one time. So if your cells are to have different links, then they have to be done one at a time. If one block of cells have all set to have the same link, then that can be removed at once. If there are different links in a block of cells, then each link must be removed individually.


What kind of formula is function in Excel?

A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.


What is the symbol that you use when you want to add up a set of numbers together on a spreadsheet?

If you mean Excel, you can add numbers one at a time with the "+" symbol. To add a larger range of cells, you need to use the sum() function. Don't forget that Excel formulae start with the "=" symbol. Example: = sum(a1:b10) As a convenient shortcut, once you type "sum(", you can select the range with the mouse.


What is a contiguous range in Excel?

There is no such thing as a non-contiguous range. A range is a group of cells that are together in a rectangular block. Non-contiguous refers to cells that are not touching. So you can have more than one range which do not touch, so what you have are non-contiguous ranges. It is possible to select non-contiguous ranges by first selecting one range and then while holding the Ctrl key, select other ranges.


How do you get excel to ignore blank cells in a chart or how can you select only specific cells to put into the chart?

Excel is too alert and observant to ignore anything. The second method is therefore the correct one.


What combines a range of cells into one cell that occupies the same amount of space in an excel worksheet?

The Merge Cells option.


How many cells are there in 1 column?

The number of cells in one column depends on the size and configuration of the spreadsheet. In Excel, for example, a standard column typically contains 1,048,576 cells.


What command combines a range of cells into one cell that occupies the same amount of space in excel?

The name is "merge and center", which combines all highlighted cells. For newer versions of Excel this is on the "Home" tab.


What is the result of pushing the END key within an Excel worksheet?

It turns the End mode on. When you then press one of the arrow keys it will move to the end of the current block of data if you are in a block, or to the start of the next block of data if you are not in a block.