[mso] Re: Hmm..another MS Word number-calculating question

Yes, you can...but it is true that embedding an Excel table would allow you
to reference the columns so that any new numbers added would automatically
add up the numbers.

In order to do it in word, you'd have to add a formula like this:

{ =SUM(A2:B1)} and put this formula field in the B2 cell. You could copy it
into the next cell, but you'd have to then go into the field (select and hit
Shift + F9) and change the cells to A3:B2...because Word only uses ABSOLUTE
cell names. 

Granted, you could do it automatically if you used VBA to calculate the
cells by adding field or bookmarks.

But short of coding up a table...doing all the formula field would take just
as long as it would to break out a desk calculator (or hit Window + R, type
CALC and hit enter) and just type in the total. 

This IS a job for Excel! ;-) 


Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html 
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html 


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of DansAttic@xxxxxxx
Sent: Tuesday, November 15, 2005 3:13 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Hmm..another MS Word number-calculating question

OK, so I now have the numbers in my Word table columns tallying perfectly,  
thanks to Anne's advice.  But now, I have another issue:
 
I have 2 columns with numbers, one is for daily  numbers that are added
after 
the previous days numbers are cleared, and the  second is for a perpetual 
tally of all daily numbers (in  other words, all the new daily numbers added
to 
the first column each day must  be added into the perpetual tally in the
second 
column, which will keep growing  every day forever).  
 
My question is this:  Is there a way I can set the rows up so that  when I 
enter the new daily number to the column in the  first row, they will 
auto-calculate into the perpetual  tally in that row?  In other words, if
the perpetual 
tally for that row  is up to 500, and today's daily number for that row is
20, 
I would like,  when adding "20" to the daily number cell in that row, for
the 
perpetual number  in that row to auto-change to "520."
 
Does anyone know if this is possible?
 
Thank you much!!
 
Dan

*************************************************************
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, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


*************************************************************
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, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: