Question on conditional formulas with text

[Patrick]

I have a scenario that I cannot figure out. I want to
find the total number of entries in one column based on
entries in another column. Here is an example:

column 1: column 2:
1 a 1 x
2 a 2 x
3 b 3 x
4 b 4 x
5 5 y
6 a 6 x

I want to add all the column 2 entries with "x" where the
corresponding entry in column 1 is "a". So the answer I
am looking for is 3.

Thanks,
Patrick

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$1:$A$6=E1),--($B$1:$B$6=F1))

where E1 houses "a" and F1 "x".

 

[Frank Kabel]

Hi Patrick
one way:
=SUMPRODUC((A1:A1000="a")*(B1:B1000="x"))

Frank