I want them all in one cell because I'm doing timecards for a construction
co. and they have different phases each day for each man, so the "1+2+4+..."
are hours per phase. If I do them in different cells, then it makes my
worksheet way too big to record a crew of 16 because that would be at least 5
cells per person, per day on a two-week period. I hope I'm making sense.
Bottom line, the document gets too big.
When I originally did just what you're suggesting, I had 23 pages to
printout when it was done and we're on a paper limit here due to expense.

"CyberTaz" wrote:

Maybe a dumb question, but why not just put the four values in separate
cells & SUM the four cells in a 5th? Such as;

A1- 1
A2- 2.5
A3- 3
A4- 4
A5- =Sum(A1:A5)

If you use the + or = in A1 it will give you the total right there, so the
=SUM in A2 is redundant. Also, by putting the values in separate cells,
changes can be made to the individual cells without having to edit a
formula.

Use a Text Box, Comment or another cell to display the operation. A Text Box
will work best if you don't want the 4 values to show 'cause you can overlay
those cells with the Text Box to hide them.

Sorry for having such a simple mind, but all that code makes me nervous if
it isn't absolutely necessary :)

Regards |:)




On 9/16/05 7:26 PM, in article
, "Deernad Construction"
wrote:

When I do that, it won't give me a sum of the numbers in A1, it just gives me
exactly what I put in A1. I've also tried to use =SUM(A1) and it just gives
a zero.
Example:
[A1] 1+2.5+3+4
[A2] Typed (=A1), Shows: 1+2.5+3+4
-or-
[A1] 1+2.5+3+4
[A2] Typed (=SUM(A1)), Shows: 0

"Tenaj" wrote:

Hi - go into cell A2 and type in an opertor (either the plus sign +, or the =
sign) and click cell A1, hit enter.
--
tenaj


"Deernad Construction" wrote:

I am using Office 2000. I have an aritmetic problem that I want to display
in one cell and then have it total those numbers in a seperate cell. I need
it to be able to automatically change the total in cell A2 if I change a
number in cell A1 I can't figure out how.
Example of how I'd like it displayed:
[Cell A1] 1+2.5+3+4
[Cell A2] 10.5