how to count#cells w/= value in other column and not count blank c

A

aganoe

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, but I do not want to
count blank cells, ex:
A B
1 Yes Yes
2 No No
3 NA No
4
5 Yes Yes
6 Yes Yes
7
8 No No
9 No No
Result for B10 should be 6 as I do not want to count row 4 and row 7

thanks in advance!
 
S

Stefi

=SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9))))


--
Regards!
Stefi



„aganoe†ezt írta:
 
S

Stefi

You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.

--
Regards!
Stefi



„aganoe†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count # of cells with same value other column? 4
How to count the numbers in a Word document? 0
How to display zero value in blank fields of Cross Tab query 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Count Blank Cells with Conditions 3
Trying to count based on multiple criteria & cell comparisons 4
Count if data falls within a range AND that has a certain criteria 1
Count column b if column a equal cell value 7

Top