answersLogoWhite

0

Without seeing your precise spreadsheet and knowing what types of figures you already have and what cells they are in, it is impossible to give you the precise formula. There are also various ways you could do it, but the function you would be most likely to use is the Sum function. So if you already have individual incomes and just want to total them, then in the cell where you want the total type in:

=Sum(

and then select the cells that you want added using the mouse and then press enter.

If your figures were in cells B1, B2, B3, B4, B5, B6 and B7 and your formula was in B8, then the formula would be:

=Sum(B1:B7)

That is telling Excel to add all the values in the cells from B1 to B7.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


What is the Excel formula to calculate the total of values in cells d7 through e20?

=SUM(D7:E20)


To calculate the sum of all the cells from E1 to E11 you would write the following formula in excel?

In another cell, you would type in =SUM(E1:E11)


What do you need in a excel cell to calculate a sum?

You need a formula. That formula can use the Sum function or it could use the plus sign, or several plus signs and even several Sum functions. Primarily it is the Sum function and the plus sign that is used for sums.


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.


A calculation used in excell?

Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.


What are some examples of Excel formulas?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)


Which formula in excel can i use to find the total cost of items?

The "Sum" formula works best.


What is an ict formula?

an ict formula is something that can caluculate a sum faster than usuall, it will work out the sum ,, and the software that is used is Microsoft excel.


How can I calculate the portfolio standard deviation in Excel?

To calculate the portfolio standard deviation in Excel, you can use the formula SQRT(SUMPRODUCT(COVARIANCE MATRIX, WEIGHTS MATRIX, TRANSPOSE(WEIGHTS MATRIX))). This formula multiplies the covariance matrix of the assets, the weights of each asset in the portfolio, and the transpose of the weights matrix, then takes the square root of the sum of these products.


What happens when you change a number within a sum formula in Microsoft Excel?

It can change a total that the formula results in.


Which one of the following is the correct Excel formula to calculate the total in the highlighted cell C10?

To calculate the total in cell C10, you would typically use the SUM function. The correct formula would be =SUM(A1:A9) if you want to sum the values in cells A1 through A9. Make sure to adjust the cell references as needed based on your specific data range.