answersLogoWhite

0

=SUM(range) or

=SUBTOTAL(9,range)

User Avatar

Wiki User

13y ago

What else can I help you with?

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 happens when a selected range is next to numbers and the SUM button is clicked?

You will find the sum of the numbers.


Is it true If each cell in a selected range is next to a row of numbers Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked?

false


What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function


To determine the average of a range of numbers click the in the formula bar then click AVERAGE.?

To calculate the average of a range of numbers in a spreadsheet, click on the formula bar and type "AVERAGE(" followed by selecting the range of cells you want to include. After selecting the range, close the parentheses and press Enter. The formula will compute the average of the specified numbers.


What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?

There is no single formula. MIN(range) and MAX(range) are the Excel formulae


What happens when autosum is clicked?

When the AutoSum feature is clicked in spreadsheet software like Microsoft Excel or Google Sheets, it automatically calculates the sum of a contiguous range of numbers directly above or to the left of the selected cell. The result is displayed in the selected cell, and the formula used for the calculation (e.g., =SUM(A1:A5)) is inserted. Users can adjust the range if needed before finalizing the formula. This feature helps streamline the process of adding up values quickly and efficiently.


What is the formula to find out the Range of a series of numbers?

subtract the lowest number from the heigest


What element points to the area where the name of a selected cell or range appears?

The element that indicates the area where the name of a selected cell or range appears is the Name Box. Located to the left of the formula bar in spreadsheet applications like Microsoft Excel, it displays the name of the currently selected cell or range and allows users to define or navigate to named ranges quickly.


What is the AutoCalculate area that displays the number of cells containing numbers in the selected range?

The Auto Calculate area in Excel shows summary statistics, including the Count of Numbers. This displays the number of cells containing numerical values in the selected range.


What is the command in autocalculate area displays the highest value in the selected range?

I didn't know there was one; I always make a formula with the MAX() function.


What command in the AutoCalculate area displays the highest value in the the selected range?

I didn't know there was one; I always make a formula with the MAX() function.