Insert values based on 2 criterias

[wamz]

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

 

[Mike H]

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!B11=B1)*(Sheet1!B24))

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

Mike

 

[wamz]

Thanks alot, that was exactly what i was looking for

 

[wamz]

thanks alot, that worked perfectly

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!B11=B1)*(Sheet1!B24))

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

Mike