answersLogoWhite

0


Best Answer

Yes it can.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can Autosum total a range of cells that contains blanks?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How does an autosum formula differ from an average formula?

An autosum formula calculates the total sum of a range of cells, while an average formula calculates the average value of a range of cells. The autosum function adds up the numbers in the selected range and can be applied to any numerical data, whereas the average function calculates the arithmetic mean of the numbers in the selected range.


What is the symbol for autosum?

The symbol for autosum in Excel is a Greek letter sigma (∑) located in the toolbar or ribbon at the top of the application. It is used to quickly add up a range of selected cells in a spreadsheet.


What is auto sum?

Autosum allows you to quickly add values in ranges of cells. If you have a column of numbers and put the cursor on the cell below them and click the Autosum, it will automatically add the cells above it by highlighting the range into the formula. If you try the same thing at the end of a row, it will add those.


To quickly invoke the SUM function on a range of cells?

Click the Autosum button which looks like this: ΣPressing the Alt and + key combination is another quick way.


How we can sum a large range of data by simply selecting a tool button in Excel?

Select your data and click the AutoSum button. That will sum each column in the range. Alternatively, click the Autosum button and fill in the range you want to Sum.


When you are proposing a range to sum Excel firsts looks for a range of cells with numbers above the active cell then to the right?

If you use the Autosum, Excel will try to detect cells that are above or right of it. If there are figures both immediately above it and immediately right of it, then it will try to sum the ones immediately above it. However, using the Autosum you can select a block of cells and Excel will put totals at the end of them, again opting for the bottom if columns of cells are involved, so you could select a row of values or a column of values. You can also just manually type in the cells you want to sum.


How do you get sum in Microsoft Excel?

Use the sum function type: =Sum( and then select the range of cells you want to sum and then type a close bracket ) Or select the cells you want to sum, go to Formulas in the ribbon, and click "Autosum"


What are step to calculate the average of a cell range using the autosum tool?

Select the cells you want to get an average of. Go to the Autosum tool and click the little arrow beside it and pick Average from the list of options. It will automatically insert the formula into an adjacent cell, usually the cell below the figures you would have selected. You could also go to the cell where you want the result to be first and then click on the Autosum tool and pick Average. It will start the function and at that point you can select the range you want to get the average of, or type it in.


Which buttons can be used to calculate the summation of a range of cells?

On your keyboard you can press the Alt and the + key to get a sum. You can also type in the SUM function in full. You can click on the Σ button too to get a sum.


What is the auto sum button in Exel?

The autosum button will insert the function "=sum(...)" and suggest (highlight) a range it finds most likely - usually adjacent cells above, or to the left, of the cell where you insert the formula.


What steps do you take to find the grand total of a cell range in an Excel worksheet?

There are various ways. The simplest would be that you could just put the cursor under the last cell of the range and click the Autosum. If the cells are in a single column above, it should select them automatically. If not, you can just change the range within the SUM function to be the cells you want to sum.


What happens when the SUM button is clicked?

Excel will attempt to sum cells by selecting nearby cells which it presumes are the ones to be selected and summed. Usually this will be the cells above. If you select a range of cells and then click the Autosum button it will use the selected cells and sum them, putting the total at the bottom of the column, or it can do it for several columns, giving a total for each.