Thanks for your reply!
According to your formula H3 = 0 (don't understand why??)

Note: between (A$2:D$2=H$2) and (A3:D3), my excell doesn't let me put a ,
(comma) I had to put ; .


"Max" escreveu:

One way ..

Put in H3:
=SUMPRODUCT(--(A$2:D$2=H$2),(A3:D3)*(A$1:D$1))

Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"nfbelo" wrote in message
...
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 but I don't know how
Can you help with this?? Thanks