| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding # of days to a date | Excel Worksheet Functions | |||
| adding days | Excel Discussion (Misc queries) | |||
| adding days correctly | Excel Worksheet Functions | |||
| add days without adding weekend | New Users to Excel | |||
| Adding days | Excel Discussion (Misc queries) | |||
Linear Mode
