Sum error when adding 31 days
 

I have a monthly total worksheet linked to multiple worksheet for each day of
the month. The sum fomula works for a 30-day month but it will not allow me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

if the sheets are in order try
=sum('01:31'!B3)

"kmaki" wrote:

I have a monthly total worksheet linked to multiple worksheet for each day of
the month. The sum fomula works for a 30-day month but it will not allow me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

=SUM('01:31'!B3)


Gord Dibben MS Excel MVP

On Tue, 11 Sep 2007 07:04:02 -0700, kmaki
wrote:

I have a monthly total worksheet linked to multiple worksheet for each day of
the month. The sum fomula works for a 30-day month but it will not allow me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'0 6'!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12' !B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B 3,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3, '25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

Only if you do not like BJ's perfectly fine method:

The reason your formula fails when you add the 31st argument is Excel's
limit of 30 arguments in any function.

But this will work
B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)
+'31'!B3)

or any other breakdown, say 1 to 15 and 16 to 21
B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3)
+SUM('16'!B3,'17'!B3,'18'!B3,'19'!B3,'20'!B3,'21'! B3,'22'!B3,'23'!B3,'24'!B3,'25'!B3,'26'!B3,'27'!B3 ,'28'!B3,'29'!B3,'30'!B3,'31'!B3)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"kmaki" wrote in message
...
I have a monthly total worksheet linked to multiple worksheet for each day
of
the month. The sum fomula works for a 30-day month but it will not allow
me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

Simply enclose the references in *DOUBLE* parens:

=Sum((1,2,3,...100,101))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"kmaki" wrote in message
...
I have a monthly total worksheet linked to multiple worksheet for each day
of
the month. The sum fomula works for a 30-day month but it will not allow me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

That's new to me. Thanks
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RagDyeR" wrote in message
...
Simply enclose the references in *DOUBLE* parens:

=Sum((1,2,3,...100,101))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"kmaki" wrote in message
...
I have a monthly total worksheet linked to multiple worksheet for each day
of
the month. The sum fomula works for a 30-day month but it will not allow
me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?

Sum error when adding 31 days
 

I first saw that a couple of years ago in a feed-back post from an OP who
said he didn't need help any more, since he solved it himself.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bernard Liengme" wrote in message
...
That's new to me. Thanks
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RagDyeR" wrote in message
...
Simply enclose the references in *DOUBLE* parens:

=Sum((1,2,3,...100,101))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"kmaki" wrote in message
...
I have a monthly total worksheet linked to multiple worksheet for each
day
of
the month. The sum fomula works for a 30-day month but it will not allow
me
to add data for a 31-day month.

B2=SUM('01'!B3,'02'!B3,'03'!B3,'04'!B3,'05'!B3,'06 '!B3,'07'!B3,'08'!B3,'09'!B3,'10'!B3,'11'!B3,'12'! B3,'13'!B3,'14'!B3,'15'!B3,'16'!B3,'17'!B3,'18'!B3 ,'19'!B3,'20'!B3,'21'!B3,'22'!B3,'23'!B3,'24'!B3,' 25'!B3,'26'!B3,'27'!B3,'28'!B3,'29'!B3,'30'!B3)

B3 =SUM(B2,'31'!B3)

Is there a better way to perform this caculation?