2006-12-20 03:49:12 · 6 answers · asked by vemula p 1 in Computers & Internet ➔ Programming & Design
type
@sum(c3:g3)
in cell h3
will returns the sum numbers in the range
2006-12-20 20:43:18 · answer #1 · answered by george t 2 · 0⤊ 0⤋
What total? How do you want to total the alphabetics? The formula in h3 would be =c3+d3+e3+f3+g3 is they were all numeric.
2006-12-20 11:56:26 · answer #2 · answered by Elizabeth Howard 6 · 1⤊ 0⤋
The cells e3 and g3 will cause problems because they are not numeric,
cells value
c3 4
d3 3
e3 b
f3 8
g3 x
2006-12-20 12:01:46 · answer #3 · answered by Anonymous · 0⤊ 0⤋
the answer will be an error because e3 and g3 cells are not in numbers.
2006-12-21 00:48:36 · answer #4 · answered by avinashgtb 1 · 0⤊ 0⤋
cells value
c3 4
d3 3
e3 b
f3 8
g3 x
h3=sum(c3:g3)
2006-12-21 07:02:32 · answer #5 · answered by sunil n 2 · 0⤊ 0⤋
You should be typing that formula in the cell you want the answer to appear in.
2006-12-20 11:54:52 · answer #6 · answered by ? 5 · 1⤊ 0⤋