i am using an excel 2003 spread sheet i have tried auto sum but it just adds up.
i am just trying to find some totals...please help
2007-03-27 04:19:42 · 10 answers · asked by flaked_rice 1 in Computers & Internet ➔ Software
Select a new cell
type into the new one the " =sum(
then click on A1
then type *
then click on A2
close brackets and hit return.
The equation should read:
=sum(A1*A2)
Good Luck
2007-03-27 04:25:50 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Select the cell you want the answer to be displayed in and in the input line put
=A1*A2
where A1 and A2 are the cells you want to multiply together.
2007-03-27 04:24:02 · answer #2 · answered by Mythago 1 · 0⤊ 0⤋
Hello their for multiplying just select the colum where u want answer and then following command.. A1 and B1 are the colums that you want the multiplication for.. pick you colums to multiply
= A1 * B1
2007-03-27 04:33:46 · answer #3 · answered by Samir 2 · 0⤊ 0⤋
type out the following in the cell where you want your answer to appear:
"=(a1)(a2)" and replace "a1" and "a2" with whatever cells your two products are in. You can also do the old fashioned "=(a1*a2)" if you want.
The notation is pretty much the same as how you would do it on paper.
2007-03-27 04:28:27 · answer #4 · answered by IW 2 · 0⤊ 0⤋
to multiply, type (without quotes) "=A1*B1" where A1 and B1 are the cells you want to multiply. Your question asks for totals, though, which is addition.
2007-03-27 04:27:18 · answer #5 · answered by ecoandy 2 · 0⤊ 0⤋
Put the value of 2 cells in brackets and put * between them
2007-03-27 04:25:00 · answer #6 · answered by xXx Catherine xXx 3 · 0⤊ 0⤋
assume A1 is 1st cell and B1 is second
put in your cell
=A1*B1
2007-03-27 04:24:10 · answer #7 · answered by JeckJeck 5 · 0⤊ 0⤋
in the formula use * instead of x. so eg. formula would be =2*5
2007-03-27 04:28:15 · answer #8 · answered by beanie 5 · 0⤊ 0⤋
click on the fx button and you can fill in the formula what you need and if in doubt click help.
2007-03-27 04:54:01 · answer #9 · answered by auisemate 1 · 0⤊ 0⤋
yes its =?*? (? = the cells)
2007-03-27 04:29:57 · answer #10 · answered by Anonymous · 0⤊ 0⤋