| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count # of cells with same value other column?
In column A, I have values equal to either YES, NO or NA. In column B, I
have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes no 5 Total I want should be 3 as B1=A1 count, B2=A2 count, B3 = A3, B4 ‰* A4 Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count # of cells with same value other column?
sorry my date is not visually clean...I'll try this:
A B 1 YES YES 2 NO NO 3 NA NA 4 YES NO 5 B5 should have a result of 3. "aganoe" wrote: In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes no 5 Total I want should be 3 as B1=A1 count, B2=A2 count, B3 = A3, B4 ‰* A4 Thanks in advance! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count # of cells with same value other column?
Try this...
=SUMPRODUCT(--(B1:B5=A1:A5)) -- Biff Microsoft Excel MVP "aganoe" wrote in message ... In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes no 5 Total I want should be 3 as B1=A1 count, B2=A2 count, B3 = A3, B4 ? A4 Thanks in advance! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count # of cells with same value other column?
=SUMPRODUCT(--(A1:A4=B1:B4))
"aganoe" wrote: In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes no 5 Total I want should be 3 as B1=A1 count, B2=A2 count, B3 = A3, B4 ‰* A4 Thanks in advance! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count # of cells with same value other column?
Thanks it works!
"Teethless mama" wrote: =SUMPRODUCT(--(A1:A4=B1:B4)) "aganoe" wrote: In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes no 5 Total I want should be 3 as B1=A1 count, B2=A2 count, B3 = A3, B4 ‰* A4 Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Count cells in a column that has a autofilter | Excel Worksheet Functions | |||
| HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
| Count cells in a column that contain dates | New Users to Excel | |||
Linear Mode
