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

Hi

In cell B9 enter
=SUM(B4:B8)

--
Regards
Roger Govier



"ajf" wrote in message
...
all I want is to add columns on an excell spread sheet: example
4b+5b+7b+8b=9b

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

On Tue, 13 Nov 2007 17:23:02 -0800, ajf wrote:

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

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...
In cell B9 enter =SUM(B4:B8)

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