sum

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.
 
D

Domenic

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.

Hi,

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

=SUM(B1:E1)

Hope this helps!
 
B

Bernard Liengme

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top