answersLogoWhite

0


Best Answer

I assume you mean the formula as used in a spreadsheet?

Place the formula in cell A4

=SUM(A1:A3)

or you can use =Sum(A1+A2+A3) - This is a loger way of doing it but for someone new to calculations in spreadsheet cells its easier to check and edit if you need to change a cell reference.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula to find the sum of cells A1A2and A3?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the formula to find the sum of A1A2and A3?

I assume you mean the formula as used in a spreadsheet? Place the formula in cell A4 =SUM(A1:A3) or you can use =Sum(A1+A2+A3) - This is a loger way of doing it but for someone new to calculations in spreadsheet cells its easier to check and edit if you need to change a cell reference.


What is the sum of the values stored in cells B4 and B5 and B6 and B7?

Don't know, but you could find out with the formula SUM(B4:B7).


What is the formula to find the sum of the cells A1 A2 A3?

There following two options should work:=sum(A1:A3) or=A1+A2+A3


What is the formula to find the sum of cells A1 A2 A3?

There following two options should work:=sum(A1:A3) or=A1+A2+A3


How can you use sum method in formula bar?

You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)You can type in the SUM function directly in the formula bar. So if you wanted to add the cells from A2 to A20, you would type in:=SUM(A2:A20)


What cell references does the formula SUM A4A13 contain?

SUM A4A13 is not a formula. It would have to be like this: =SUM(A4:A13) The cells are a range and it is a relative reference. Cells A4, A5, A6, A7, A8, A9, A10, A11, A12 and A13 are the cells in the range.


What is the name of the formula use when adding multiple cells together?

sum~ Apex


If you used the Excel formula SUM(A2A4) what will be calculated?

The values in cells A2, A3 & A4 will be added together - and the result displayed in the cell that contains the 'sum' formula.


What is a formula that will sum the values contained in spreadsheet cells A2 through A5 and C12?

=SUM(A2:A5)+C12


Monthly sales formula?

Without having the actual layout of your worksheet and seeing where the cells are that you have your figures in, it is impossible to give a definitive answer. It will involve using the SUM function to sum up the individual sales for a particular month. So if your list of sales were in the cells C3 to C25, your formula would be:=SUM(C3:C25)So it is a matter of adjusting the formula to suit the cells that you have your data in.


Is a group of cells called a cell range or range in excel?

You create them. A range is a collection of cells, you choose.EXAMPLE:You want to find the sum of a range of cells from C2 through C23. The range would be C2:C23. The formula to find the sum of this range of numbers is =SUM(C2:C23).


How can i get the cell values of a group of cells say 5 their values being 1000 2000 30004000 and 5000 respectively the answr is 15000 bt instead i want to get the right a but omit 1 cell value?

Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.Use the SUM function to add all of the cells, or just use the + with the cells you want if you want to omit one. You can put the formula wherever you want in relation to the cells with those numbers in them.