A
ajf
all I want is to add columns on an excell spread sheet: example
4b+5b+7b+8b=9b
4b+5b+7b+8b=9b
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi
In cell B9 enter
=SUM(B4:B8)
In cell B9 enter
=SUM(B4:B8)
G
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
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
D
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...
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...