more than 30 fields in one Sum function

[Guest]

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine. for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed in the
current file format.

i copied the file from a month that have 30 days and i added a new column
for the 31st day. i tried to insert the field of the 31st day in the function
manually. this is where i received the error.

any idea?

 

[Guest]

If the numbers to be totalled are in a single column or single row and don't
have any other information mixed in between them in the column/row, then you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11

 

[Bob Phillips]

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

If the numbers to be totalled are in a single column or single row and
don't
have any other information mixed in between them in the column/row, then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine. for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed in
the
current file format.

i copied the file from a month that have 30 days and i added a new column
for the 31st day. i tried to insert the field of the 31st day in the
function
manually. this is where i received the error.

any idea?

 

[Guest]

I'd never thought about it that way. Very sneaky ... I like it!

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

If the numbers to be totalled are in a single column or single row and
don't
have any other information mixed in between them in the column/row, then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine. for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed in
the
current file format.

i copied the file from a month that have 30 days and i added a new column
for the 31st day. i tried to insert the field of the 31st day in the
function
manually. this is where i received the error.

any idea?

 

[Guest]

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

If the numbers to be totalled are in a single column or single row and
don't
have any other information mixed in between them in the column/row, then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine. for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed in
the
current file format.

i copied the file from a month that have 30 days and i added a new column
for the 31st day. i tried to insert the field of the 31st day in the
function
manually. this is where i received the error.

any idea?

 

[Bob Phillips]

OK I missed a bracket, but you get the idea (as did JL), especially as I
said it in words as well. I certainly don't mean the latter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

If the numbers to be totalled are in a single column or single row and
don't
have any other information mixed in between them in the column/row,
then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the
error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11


:

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a
column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of
order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine.
for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed
in
the
current file format.

i copied the file from a month that have 30 days and i added a new
column
for the 31st day. i tried to insert the field of the 31st day in the
function
manually. this is where i received the error.

any idea?

 

[Guest]

I thought I was the only one allowed to have Typos in responses, I make
enough of them, there should not be any left for anyone else.

OK I missed a bracket, but you get the idea (as did JL), especially as I
said it in words as well. I certainly don't mean the latter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

If the numbers to be totalled are in a single column or single row and
don't
have any other information mixed in between them in the column/row,
then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the
error
anyhow].
If your numbers are broken up with other information (blank cells don't
count), then you can just do away with SUM and simply add them together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11


:

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a
column
that calculates the total of each month for each customer, and in the
remaining columns i have the day's date, under which the number of
order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just fine.
for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are allowed
in
the
current file format.

i copied the file from a month that have 30 days and i added a new
column
for the 31st day. i tried to insert the field of the 31st day in the
function
manually. this is where i received the error.

any idea?

 

[Bob Phillips]

You must be joking, there are plenty for all of us, infinite it seems to me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I thought I was the only one allowed to have Typos in responses, I make
enough of them, there should not be any left for anyone else.

OK I missed a bracket, but you get the idea (as did JL), especially as I
said it in words as well. I certainly don't mean the latter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))
:

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

If the numbers to be totalled are in a single column or single row
and
don't
have any other information mixed in between them in the column/row,
then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the
error
anyhow].
If your numbers are broken up with other information (blank cells
don't
count), then you can just do away with SUM and simply add them
together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11


:

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for
each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a
column
that calculates the total of each month for each customer, and in
the
remaining columns i have the day's date, under which the number of
order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just
fine.
for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are
allowed
in
the
current file format.

i copied the file from a month that have 30 days and i added a new
column
for the 31st day. i tried to insert the field of the 31st day in
the
function
manually. this is where i received the error.

any idea?

 

[Guest]

the only time typos really bothered me is when I thought someone had a typo,
but it was a function or format of which I was not aware. I like it when
someone catches mine before someone gets too confused.

You must be joking, there are plenty for all of us, infinite it seems to me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I thought I was the only one allowed to have Typos in responses, I make
enough of them, there should not be any left for anyone else.

OK I missed a bracket, but you get the idea (as did JL), especially as I
said it in words as well. I certainly don't mean the latter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))
:

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

If the numbers to be totalled are in a single column or single row
and
don't
have any other information mixed in between them in the column/row,
then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the
error
anyhow].
If your numbers are broken up with other information (blank cells
don't
count), then you can just do away with SUM and simply add them
together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11


:

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for
each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a
column
that calculates the total of each month for each customer, and in
the
remaining columns i have the day's date, under which the number of
order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just
fine.
for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are
allowed
in
the
current file format.

i copied the file from a month that have 30 days and i added a new
column
for the 31st day. i tried to insert the field of the 31st day in
the
function
manually. this is where i received the error.

any idea?

 

[Guest]

hey guys.....

im sure typos are allowed for everyone of you just like easy (silly)
questions are allowed for us the beginners.... Thank u all for posting
here... i really enjoyed reading ur small chat log
--
Croco

the only time typos really bothered me is when I thought someone had a typo,
but it was a function or format of which I was not aware. I like it when
someone catches mine before someone gets too confused.

You must be joking, there are plenty for all of us, infinite it seems to me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I thought I was the only one allowed to have Typos in responses, I make
enough of them, there should not be any left for anyone else.

:

OK I missed a bracket, but you get the idea (as did JL), especially as I
said it in words as well. I certainly don't mean the latter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I think you meant
=SUM((A2,A3,A6,A7,A10),(A11...))
or
=SUM(A2,A3,A6,A7,A10,(A11...))
:

You can also group them like so

=SUM(A2,A3,A6,A7,A10),(A11...))

which gets you more than 30.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

If the numbers to be totalled are in a single column or single row
and
don't
have any other information mixed in between them in the column/row,
then
you
do not have to reference each cell individually.
=SUM(A2:A32) is the same as =SUM(A2,A3,A4...A32) [which gets you the
error
anyhow].
If your numbers are broken up with other information (blank cells
don't
count), then you can just do away with SUM and simply add them
together
and
the # of arguments problem goes away:
=A2+A3+A6+A7+A10+A11


:

dear all,

thanks in advance for ur help..

i have an excel sheet (monthly) that displays the daily order for
each
customer during the whole month.

Meaning that, i have in the first column cust name, then i have a
column
that calculates the total of each month for each customer, and in
the
remaining columns i have the day's date, under which the number of
order
placed bu the cust is inserted.

For months that have 30 days, the total sum formula works just
fine.
for
months that have 31 days, it gives me the following error:
more arguments have been specified for this function than are
allowed
in
the
current file format.

i copied the file from a month that have 30 days and i added a new
column
for the 31st day. i tried to insert the field of the 31st day in
the
function
manually. this is where i received the error.

any idea?