What happened when you used the formula? What formula did you use? And where
did you put it?

I'd try a shorter sample:

In A9:
=SUMPRODUCT($B$1:$E$1,B9:E9)
with data in columns B:E.

It worked ok for me with nontext (numbers or empty) in those cells.


lob wrote:

Thanks Dave:
This did not work. I will try to explain in a different way.
Multiply cells v10*v1, w10*w1, x10*x1, y10*x1 (and so on) hb10*hb1 and
have the sum of these values entered in a10.
Multiply cells v11*v1, w11*w1, x11*x1, y11*x1 (and so on) hb11*hb1 and
have the sum of these values entered in a11.
Multiply cells v12*v1, w12*w1, x12*x1, y12*x1 (and so on) hb12*hb1 and
have the sum of these values entered in a12.
(and so on)
(and so on)
Multiply cell v172*v1, w172*w1, x172*x1, y172*x1 (and so on) hb172*hb1
and have the sum of these values entered in a172.
I will be inserting more rows between rows 10 and 171 in the future
when required.
Is this possible to do? As you can likely tell, I am okay with basic
formulas, but get a bit lost when they get complicated.
Thanks, Lob

--

Dave Peterson