View Single Post
  #4   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Noodles wrote:
Paul B said it could be done, but not how to do it.

Need to add figures in column. What I am doing now I'm sure is the hard
way:

A B C D
1
2 15.65 15.65 =Sum C1+A2 =Sum D1+B2
3 15.44 15.44 =Sum C2+A3 =Sum D2+B3


After I get the columns totaled I then delete columns C & D etc because they
are not needed anymore. There as to be an easier way.


-----------

One easier way would be to not bother deleting the working columns. Are
they hurting something by being there? Or you could just resize the
column width for C and D down to near 0 so they're still there but don't
show unless you widen them again.

If you're relying on the results of column C and D, then I personally
would never delete them. That also deletes any audit path you have to
figure out later why you've got some result that doesn't look right to you.

Good luck...

Bill