Insert values based on 2 criterias

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A B C D
1 France Spain Italy
2 400010 6 % 1 % 3 %
3 400020 2 % 4 % 3 %
4 400040 1 % 2 % 3 %
5 .
6 .
7 .
8
I would like to put in the percentages into another sheet that looks like
this:
400010 France 6%
400020 Spain 4%
400040 Italy 3%

How can i do that. I've tried with if sentences but it does not work
 
Hi,

I'm making the assumption you have

400010 France

on your 'other sheet and it's just the percentage you want. If that's
correct try this:-
=SUMPRODUCT((Sheet1!A2:A4=A1)*(Sheet1!B1:D1=B1)*(Sheet1!B2:D4))

This returns the % with your table laid out like below on sheet 1.

Mike
 
thanks alot, that worked perfectly

Mike H said:
Hi,

I'm making the assumption you have

400010 France

on your 'other sheet and it's just the percentage you want. If that's
correct try this:-
=SUMPRODUCT((Sheet1!A2:A4=A1)*(Sheet1!B1:D1=B1)*(Sheet1!B2:D4))

This returns the % with your table laid out like below on sheet 1.

Mike
Click to expand...
 
Back
Top