Formula for adding Columns

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance
 
Your problem is not clear... pl. provide more information with sample data.

If you want to add A1, B1, C1 in D1 then use
=A1+B1+C1 in D1
 
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...
 
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...
 
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
 
Hi,

If I understand you want a single formula to give the result of all of the
rows: suppose your data runs from row 2 to 100 then

=SUMPRODUCT(C2:C100-(D2:D100+E2:E100))
 
Back
Top