This would be my formula for cell H3

=SUMPRODUCT(A3:D3,$A$1:$D$1,--($A$2:$D$2=$H$2))


"nfbelo" wrote:

> Hi,
> I'm working in a worksheet that has:
> A B C D H
> 1 8 5 7 6
> 2 EXX GAL SHE EXX ... EXX
> 3 25 30 20 15 290
> 4 21 45 30 12 240
> 5 45 36 21 36 576
>
> I need to put in the H column:
> (25*8)+(15*6)= 290 with the criteria EXX
> (21*8)+(12*6)= 240 "
>
> I think that I should use a SUMPRODUCT or a SUMIF
> Can you help with this??
>