Summing based on multiple conditions

I have been trying to search an array and cannot find the correct combination of functions to get the information I want. I might need a macro to do this but I will try anything. Here is an example:

1 A 1
1 B 2
2 A 3
2 B 4
3 A 5
3 B 6

I want to search for 3 and A and return the value in the 3rd column. I have tried several functions but cant figure out how to make sure I get the correct value in the 2nd column that corresponds to the value in the 1st column.

Thank for your help.

Try:

=Sumproduct(--(A1:A100=3),--(B1:B100="A"),C1:C100)

you can replace 3 and "A" with cell references containing those 2 items.

also, adjust ranges to suit.

Please note: I changed your title for you as it did not conform to our Forum Rules... please remember to do be more specific in the title next time.

Which one is supposed to match that code?

So are we adding the price of 167 and price of B in same line?

e.g.

=Sumif(A1:A100,167,B1:B100)+Sumproduct(--(A1:A100=167),--(C1:C100="B"),D1:D100)

Example please...

=Index(B$2:B$10,Match(1,($A$1:$A$10=167)*($C$1:$C$10="B"),0),0)

and

=Index(D$2:D$10,Match(1,($A$1:$A$10=167)*($C$1:$C$10="B"),0),0)

adjust ranges to suit....

Maybe your column A is text:

Try:

=Index(B$2:B$10,Match(1,($A$1:$A$10="167")*($C$1:$C$10="B"),0),0)

and

=Index(D$2:D$10,Match(1,($A$1:$A$10=167)*($C$1:$C$10="B"),0),0)

Post the actual spreadsheet please!

My bad... I forgot a function in there:

=INDEX(B$2:B$10,MATCH(1,INDEX(($A$1:$A$10=167)*($C$1:$C$10="B"),0),0))

and

=INDEX(D$2:D$10,MATCH(1,INDEX(($A$1:$A$10=167)*($C$1:$C$10="B"),0),0))