sum
You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you
"Gord Dibben" wrote:
Jr
What is "didn't work"? Error message? No SUM? Noises from your Hard Drive?
=SUM(D1419:D1555) is the standard method of summing a range.
Maybe your numbers are not numbers but text that look like numbers.
Post back.
Summing 30 cells at a whack for 100 to 150 cells is a lot of typing.
Gord Dibben MS Excel MVP
On Thu, 4 Jan 2007 17:05:00 -0800, Jr wrote:
I tried using =sum(d1419:d1555) but that didn't work. I will try the extra
parenthesis
thanj you
"Peo Sjoblom" wrote:
=SUM((a1,a3,a5 and so on up to 30),a50,a55 and so on))
just wrap each set of 30 in extra parenthesis
if you mean sum a contiguous range, use
=SUM(A1:A150)
Regards,
Peo Sjoblom
Jr wrote:
I'm triing to add up every thing in one column but I can get past 30 rows. is
there a way of increasing the number. In my speadsheet I have about 1500 rows
and I'm triing to add up 100 to 150 rows at a time.
|