Excell spread sheet
 

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

Excell spread sheet
 

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

Excell spread sheet
 

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

Excell spread sheet
 

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