Previous Topic Next Topic

Count 2 values in one column and 1 val in oth

Solved/Closed
JJ - Mar 31, 2010 at 04:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 1, 2010 at 10:28 PM
Hello,

I have two column lists (two values in first column and one value in the other)

e.g. Column A has the following values: A B C B B A C

Column B has the following values: Yes


I need a formula to count how many A's & B's there are if column B is = Yes

Please help
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 1, 2010 at 10:28 PM
suppose sample data is like this (row 1 has headings H1 and H2)

H1 H2
A YES
B YES
C
B YES
B YES
A
C YES


try this formula in an empty cell

=SUMPRODUCT((A2:A8="B")*(B2:B8="yes"))
you will get 3
0