Excell spread sheet

[Guest]

all I want is to add columns on an excell spread sheet: example
4b+5b+7b+8b=9b

 

[Roger Govier]

Hi

In cell B9 enter
=SUM(B4:B8)

 

[Gord Dibben]

None too clear what you want.

Are these cell addresses?

Numbers are row references and letters are column references?

Do you want to SUM them?

=b4+b5+b7+b8 entered in b9 maybe?


Gord Dibben MS Excel MVP

 

[David McRitchie]

Your question is ambiguous, and certainly not depicted as
an Excel formulas, (note spelling of Excel)
and assuming that you accidentally left out B6
I'd go with Roger's solution only I would something like
B9: =SUM(B$4:OFFSET(B9,-1,0))
the difference is that you can insert rows without having to
change your formula. Read more about at
http://www.mvps.org/dmcritchie/excel/offset.htm
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Roger Govier" wrote...