Searching for a value in an Array
1 way
E2=SUMPRODUCT((A2:A100="usa")*(B2:B100=1)*(C2:C100 ))
another: put country in D2 and model number in D3
E2=SUMPRODUCT((A2:A100=D2)*(B2:B100=D3)*(C2:C100))
"Farah" skrev:
I have a master price list were I have in column A the country name, and in
column B the machine model number and in column C the price.
Obviously you can find the same machine for many countries with different
prices, I need a formula were I can extract for a certain country the price
of a certain machine.
|