Question on conditional formulas with text

P

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
 
A

Aladin Akyurek

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

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