[mso] Re: accumulating values in Excel from another worksheet

Note that it should be a colon between the d176 and d178, not a semicolon.

Also note that the formula has shown on my PC as =3Dsum ...   The 3D was 
inserted by the e-mail program and is not part of the formula.

However, best solution for these slightly complex range selections is to use 
the mouse.  I.e., type the =sum(, then use the mouse to select the area you 
want to sum.  That way the syntax will be correct.

Regards, Dave S

----- Original Message ----- 
From: "Melody Kennedy" <mkennedy@xxxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Thursday, August 16, 2007 12:53 AM
Subject: [mso] Re: accumulating values in Excel from another worksheet


> If the cells are in a row you should be able to do
> =3Dsum('costbuild'!d176;d178)
>
> Melody=20
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Joyce West
> Sent: Wednesday, August 15, 2007 10:42 AM
> To: MS office queries
> Subject: [mso] accumulating values in Excel from another worksheet
>
> I have a programme with several worksheets - the principle worksheet
> called COSTBUILD
>  =20
>  I wish to accumulate the values of several cells into another
> worksheet, and the only way I can make it work is using the following
> formula
>  =20
>  =3DCOSTBUILD!D176+COSTBUILD!D177+COSTBUILD!D178 and so on.
>  =20
>  I am sure there must be a less labourious method and would appreciate
> any tips.
>  =20
>  THanks
>  =20
>  Norman West
>      =20
> ---------------------------------
> For ideas on reducing your carbon footprint visit Yahoo! For Good this
> month.
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
> or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top.  This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group.  This group will not allow for posting of emails, but will allow
> you to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: