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))))

here, the data is in H1:L2.

Still puzzled by the N function!?!


"Harlan Grove" wrote in message
ups.com...
peter dmz wrote...
Thanks Harlan -- absolutely brilliant! I can get rid of the hard coding
as
follows:

=SUMPRODUCT($A1:E1,N(OFFSET($A2:E2,0,COLUMNS($A2 :E2)-COLUMN($A2:E2))))
...

This works because your ranges begin in column A. If they started in a
different column, you'd need

COLUMNS(rng)-COLUMN(rng)+CELL("Col",rng)-1