How do I count # of cells with same value other column?

's Computer Specifications

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!

's Computer Specifications

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!
>

's Computer Specifications

Try this...

=SUMPRODUCT(--(B1:B5=A1:A5))

--
Biff
Microsoft Excel MVP

"aganoe" <(E-Mail Removed)> wrote in message
news:781AD810-392F-4A57-92FF-(E-Mail Removed)...
> 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!
>

's Computer Specifications

=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!
>

's Computer Specifications

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!
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to count#cells w/= value in other column and not count blank c	aganoe	Microsoft Excel Worksheet Functions	4	9th Apr 2010 11:36 AM
Count cells w/values in column if the data in column a matches cri	mdcgpw	Microsoft Excel Worksheet Functions	3	11th Jan 2009 09:00 PM
Count cells every 12th column?	tours@aldoleopold.org	Microsoft Excel Programming	3	2nd Jul 2008 06:52 PM
Count number of cells and total in one column, based on another column suffix	Pierre	Microsoft Excel Worksheet Functions	5	31st Oct 2007 12:28 AM
Count cells in a column that has a autofilter	=?Utf-8?B?SXJ2?=	Microsoft Excel Worksheet Functions	1	31st Oct 2006 07:39 PM