Summing Formula
 

Can someone please suggest a formula for summing the contents in a row - for
a range consisting of the 12 columns immediately to the left of a specified
column in that row

--

Cheers

Steve Wilson
GISBORNE
NZ

How do you (intend to) specify the start column?

Steve W Wrote:
Can someone please suggest a formula for summing the contents in a row -
for
a range consisting of the 12 columns immediately to the left of a
specified
column in that row

--

Cheers

Steve Wilson
GISBORNE
NZ


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275162

If the specified cell would be for instance N10

=SUM(OFFSET(N10,,-1,,-12))

will sum B10:M10

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Steve W" wrote in message
...
Can someone please suggest a formula for summing the contents in a row -
for a range consisting of the 12 columns immediately to the left of a
specified column in that row

--

Cheers

Steve Wilson
GISBORNE
NZ

hi,
select a cell in which you want the sum to be shown.If B2:H2 is to be
totalled in A2, put the formula in A2 =sum(B2:H2)
K.S.Warrier

"Aladin Akyurek" wrote:


How do you (intend to) specify the start column?

Steve W Wrote:
Can someone please suggest a formula for summing the contents in a row -
for
a range consisting of the 12 columns immediately to the left of a
specified
column in that row

--

Cheers

Steve Wilson
GISBORNE
NZ


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275162

"Steve W" ha scritto nel messaggio
...
Can someone please suggest a formula for summing the contents in a row -
for
a range consisting of the 12 columns immediately to the left of a
specified
column in that row

--

Ciao Steve,
I think you can use:
=SUM(INDIRECT("rc[-12]:rc[-1]",FALSE))

That you can put in a reference to a definited name (es: sum12)
so you can use in worksheet =sum12

Or you can change style to reference from A1 to R1C1 ed use:
=SUM(rc[-12]:rc[-1])

ivano