sum

  • Thread starter Thread starter chavi
  • Start date Start date
C

chavi

I am new to this. I will like to sum columns b throu e in
a table that contains 35 rows so the result of every row
in in colum f.
 
chavi said:
I am new to this. I will like to sum columns b throu e in
a table that contains 35 rows so the result of every row
in in colum f.
Click to expand...

Hi,

Assuming your data starts in Row 1, try putting this formula in F1 and
copy down:

=SUM(B1:E1)

Hope this helps!
 
If I understand you correctly:
In F1 enter =SUM(B1:E1), this will display the result of B1+C1+D1+E1
Copy this down to F35 - the quickest way is to double click the F1 fill
handle (black square in its lower right corner)

Best wishes
 
f1: = SUM(B1:E1)

and copy down to F35.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top