answersLogoWhite

0


Best Answer

=SUM(D7:E20)

User Avatar

Wiki User

โˆ™ 2010-05-24 14:43:58
This answer is:
User Avatar
Study guides

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

โžก๏ธ
See all cards
3.86
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
21 Reviews

Add your answer:

Earn +20 pts
Q: What is the Excel formula to calculate the total of values in cells d7 through e20?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you calculate a particular formula in an Excel worksheet?

It depends on the formula you choose. If you have autocalculate turned on (default setting) you will not need to do anything after you enter the formula; Excel will calculate automatically any time related cell values change.


What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?

You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.


What is underlying formula in Excel?

An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.


How do you display Sales Amt on Excel 2013?

You would calculate it using the Sum function. It will depend on what cells your values are in as to what form the actual formula will take.


How do you change a formula back to a number on Excel?

You can copy and past values.


What is the definition of a cell reference?

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.


What is auto calculate in Excel?

Allows Excel to automatically calculate formulas in real time. When a referenced cell changes, the formula automatically updates.


What is a mathematical statement used to calculate a value called in excel?

A formula.


What is it called when you want to calculate something in Excel?

It is called creating a formula.


What is a formula to calculate the largest value using cells x100 through x111 and y20 through y57 in excel?

=MAX(X100:X111,Y20:Y57)


Are there any limitations to the exchange process between Excel and other Microsoft applications?

There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.

People also asked