=SUM((A2:A6=A8)*(INDEX(C2:F6,0,MATCH(B8,C1:F1))*(B 2:B6)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chad" wrote in message
...
Harlan,
Thanks for your answer. I ran into something else that I need your
help on though. It is using the same information but requires a
sumproduct
formula. Let me show you.

a b c d e f
1 200701 200702 200703 200704
2 Promo1 .02 1 2 3 4
3 Promo2 .01 5 6 7 8
4 Promo3 .03 9 10 11 12
5 Promo1 .12 13 14 15 16
6 Promo1 .07 17 18 19 20
7
8 Promo1 200701 13.19

Again, I would like the user to define which Promo and Week. However,
instead of outputting a sum, I was wondering if it were possible to output
the weighted average of all of the Promo1's in Week 200701 (which is just
the
sumproduct of the two/sum of the related values in column b) Thanks again
for all of your help.

Best,
Chad



"Harlan Grove" wrote:

Harlan Grove wrote...
....
=SUMIF(A2:A6,"Promo1",INDEX(B2:E6,0,MATCH(200702, B1:E1)))

Didn't notice the entries in row 8. Make that

=SUMIF(A2:A6,A8,INDEX(B2:E6,0,MATCH(B8,B1:E1)))