answersLogoWhite

0

Many functions can be used to calculate a value. It depends on what exactly what you want to do. To total a range of cells you use the SUM function, one of the most commonly used functions. The following will add the values in all the cells from A2 to A20.

=SUM(A2:A20)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you calculate sine value without using math function?

Using its Taylor-series.


How do you calculate mid value in statistics using Excel?

You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:=MEDIAN(A2:D50)


What the feature can generate a series of values into adjacent cells based on the value of cells?

Auto Fill is the feature that can generate a series of value into adjacent cells based on the value of other cells.


What feature can generate a series of values into adjacent cells based on the value of other cells?

Auto Fill is the feature that can generate a series of value into adjacent cells based on the value of other cells.


How do you calculate average value of a function?

64084096071065


How is solving for a specified variable in a formula similar to finding a solution for an equation or inequality?

With a formula, you know the variable's value, and you have to calculate the value of the function of it. With an equation, you know the function's value, and you have to calculate the value of the variable.


How is solving for a specified variable in a formula different to finding a solution for an equation or inequality?

With a formula, you know the variable's value, and you have to calculate the value of the function of it. With an equation, you know the function's value, and you have to calculate the value of the variable.


What function would be used to calculate the future value of an investment?

The FV() function.


What Excel function can be used to calculate the futue value of any investment?

The FV function.


How do you evaluate functions?

To evaluate a function means to replace the variable with some value, and calculate the value of the function. For example, in the parabola y = x2 (or, using functional notation, f(x) = x2), if you replace x with 10, and calculate x2, you are evaluating the function for that specific value.


What is the approximate value of the function at x equals 5?

To provide an approximate value of the function at ( x = 5 ), I would need the specific function or context you're referring to. If you can provide the equation or details about the function, I can help you calculate or estimate the value.


How can I use the scipy differentiation function to calculate the derivative of a mathematical function?

To calculate the derivative of a mathematical function using the scipy differentiation function, you can use the scipy.misc.derivative function. This function takes the mathematical function, the point at which you want to calculate the derivative, and the order of the derivative as input parameters. It then returns the numerical value of the derivative at that point.