Gary

Set up the top row as you have indicated you know how. Select the cell in
column F that has your formula and move the curser to the lower left corner
and watch for it to change from a large white plus sign to a smaller back
plus sign. Once it has you have found the "Fill Handle" click and drag this
to the bottom of your data. Depanding on your layout you may be able to
double click on the fill handle and it will automatically fill to the bottom
of your data. One of these ways will hopefully help.

Mike Rogers

"" wrote:

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In other
words, I want to take each line, start with sales (C) subtract fees (D) and
Tax (E) to get a net Sales figure. I know how to do it one cell at a time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can I
find it in any "Help" resource. So I really appreciate your interest...



"Simon Lloyd" wrote:


Do you want to SUM them then add them or just add rows across?, can you
explain a little more?

Gary;230898 Wrote:
Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518