From: aganoe on 7 Apr 2010 20:58 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! From: aganoe on 7 Apr 2010 21:08 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! > From: T. Valko on 7 Apr 2010 21:16 Try this... =SUMPRODUCT(--(B1:B5=A1:A5)) -- Biff Microsoft Excel MVP "aganoe" wrote in message news:781AD810-392F-4A57-92FF-619475F38D43(a)microsoft.com...> 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! > From: Teethless mama on 7 Apr 2010 21:29 =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! > From: aganoe on 8 Apr 2010 06:30 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! > >  |  Pages: 1 Prev: Formula to Return ageNext: how do I change number format from 3,999.89 to 399989