Summing Formula

[Steve W]

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]

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

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

 

[Peo Sjoblom]

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)

 

[K.S.Warrier]

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

 

[ivano]

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