sumproduct

[mark1]

OK,
I have three rows of numbers, row A, B and C. Each row
has three numbers a piece. Looks like this:
A-> 10 20 30
B-> X X X
C-> 40 50 60

I don't want to use row B in my calculation, so I X'd it
out.

Then I have a column of six numbers, column D. Looks like
this:

1
2
3
4
5
6

How can I use either sum or sumproduct or anything to get
the numbers in A and C multiplied by column D? Final
product should come out to 910.

Thanks!!

 

[Peo Sjoblom]

One way

=SUM((A1:C1)*(TRANSPOSE(D13)),(A3:C3)*(TRANSPOSE(D46)))

entered with ctrl + shift & enter