Formula that will calculate sum in excel?

Answer 1

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.

Answer 2

The simplest way is to use the SUM function to add up the revenue for the year. The specific implementation will depend on where the values are, so it will depend on what way you have the individual revenue figures entered. There are many ways that you may have them, like with monthly totals or regional totals or totals for individual shops, amongst other ways. Say you have the revenue figures individually listed in all the cells from B2 to B125, you could have the following SUM function, in cell B126:

=SUM(B2:B125)

Answer 3

You can calculate totals in many ways, but most commonly by using the SUM function. So if you wanted to total all the cells between A2 and A20, in another cell you would enter the following formula:

=SUM(A2:A20)