SUMPRODUCT or SUMIF or ...
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
|