Search : in
By :

Compare Values in two columns and count

KjO, on Oct 21, 2009 7:28:41 pm BST 
 Report this message to moderators

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.

Thanks

Configuration: Windows XP
Firefox 3.5.3

Best answers for « Compare Values in two columns and count » in :
Excel - Extract identical cells of 2 columns Show Excel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that...
Excel - Comparing columns and returning value ShowExcel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......