Try...

=SUMPRODUCT(--(A6:F6=H1),A2:F2,A4:F4)

....where H1 contains your criterion.

Hope this helps!

In article ,
Kstalker
wrote:

Biff.

Basically the 'B9' reference sets the condition that needs to be met in
row 6. So where row 6 = cell B9 then I need to sumproduct rows 2 and 4.
So the answer I believe should be 7*9+8*8+9*7 = 190. However I cannot
get this to work based on setting criteria.


A B C D E F
1 12 2 5 6 5 9
2 2 5 7 8 9 11
3 8 8 5 4 7 6
4 3 2 9 8 7 5
5
6 0 0 2 2 2 0
7
8
9 2


Thanks

Kristan