Hello,
What is the Excel formula to I compare values in two different columns and count the number that meets my criteria.
Example:
Column A Column B
Y 1
Y 0
Y 0
Y 1
N 1
N 0
The criteria is I want to see count how many 1's in column B have a corresponding Y in column A. So in this example there are 2 1's with Y's.
Just for further clarification. If Column B=Y and Column A=1 then count.
ThanksConfiguration: Windows XP
Firefox 3.5.3
