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??
|