Insert values based on 2 criterias


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
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements

G

Guest

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

Top