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