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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top