It sounds like you want something like:
=SUMPRODUCT($v$1:$hb$1,v9:hb9)
as the formula in A9.
And drag down to row 172.
lob wrote:
<<snipped
Hi There
It sounds as if this is related to a question I have.
The area on my spreadsheet that I will enter whole numbers is from V9
to HB172.
A value will be entered in many columns along any given row.
For each one of these values entered, I would like to multiply that
value with a value entered in row 1 for each of the columns. The
solution will be entered in column A and added with all other solutions
in that row.
example:
a10=10 a15=15 a25=25
v1=(1*10)+(7*25) v10=1 v15=0 v25=7
q1=(2*10)+(6*15) q10=2 q15=6 q25=0
r1=(3*10) r10=3 r15=0 r25=0
s1=(5*15) s10=0 s15=5 s25=0
Any suggestions what formula and formatting to put in column 1.
Thanks in advance, Lob
--
Dave Peterson
|