peter dmz wrote...
Thank again -- I was just realizing that problem myself. I came up with
this alternative, which seems to work

=SUMPRODUCT($H1:L1,N(OFFSET($H2:L2,0,COLUMN(L2)-COLUMN($H2:L2))))
....

That works. I tend to use named ranges, so I don't split apart my range
references, but splitting does make for shorter formulas.

Still puzzled by the N function!?!
....

OFFSET only returns Range references. OFFSET called with array 1st, 2nd
or 3rd arguments returns something what seems to be an array of range
references. Excel can't deal with such beasts when used as arithmetic
operands or arguments to most functions. Fortunately, N() is one of the
exceptions, and it effectively converts arrays of range references to
arrays of numbers (note: it converts entries that aren't numeric into
numeric zero). The T() function does the same for strings.
CELL("Contents",.) isn't reliable.