Formula with LOOKUP but with 2 columns

Hello, can you help me write a formula using LOOKUP or IF or something else, I'm at a loss, or maybe it can't be done.
I want to calculate the value from a column (A) but only add values from rows if set conditions are met in column B and column C

so the formula wirtten in a cell in List 1 will use values from columns in List 2, which has 3 columns:
////AAA BBB CCC
1 7 4.1 f
2 15 4.2 g
3 5 4.2 i
4 89 4.3 g
5 6 4.2 g

So basically, if I choose to combine for instance the value "4.1" with "g" then I want to sum up the values from column A, but only those which have the value "4.1"in column B and the value "g" in column C.

I thought LOOKUP would be the best but it doesn't seem to want to combine 2 columns.
I started with =LOOKUP("4.1";List2!I:I;SUM(List2!G:G)) but that's only the 1 value in 1 column + it's not even working, anyone has an idea?
Marianka

Hello
Welcome to the forum
Use this formula

=SUM(IF(B1:B10=4.1,IF(G1:G10="g",A1:A10,0)))

change the range as required
This is an array formula to use this copy it from here
then press F2 on the cell where you want the result.....cursor will appear....now paste the formula and press CTRL+SHIFT+ENTER instead of just enter as we usually do...

Hope it helps

If you are satisfied just click on ADD REPUTATION below.....

Regrds
Sourabh Gupta

ohhh
I forgot that lolll
=SUMIFS(A:A,B:B,4.1,G:G,"g")
we can use this too

Originally Posted by XOR LX

@sourabhg98

Why use a CSE formula when we have SUMIFS and SUMPRODUCT?

@bebo021999

We've just been talking about this!

http://www.excelforum.com/excel-form...y-formula.html

Really not a good idea to use entire column references in SUMPRODUCT!

Regards

Actually I have learnt to use array formulas in the past few days and I was quite excited to use them......LOL

Thank you all so much, SUMIFS works like a charm, you are all so fast, thank you!

Originally Posted by XOR LX

I did precisely the same! I think we all go through an "array formula phase" at some point in our lives, in which we use them just about everywhere!

Regards

Yehh....it happens!!