CountIF matching cells

R

Rod

I have two columns of data. I want to count how many times
a datum in the first column matches the corresponding
datum in the second column's corresponding cell. e.g.
Column A Column E
3 7
4 4
2 5
21 21
4 12
3 3

The return should be 3 since the numbers 4, 21 and 3 in
column A are matched with the same numbers across from
them in column E.

Thanks in advance for any help possible.
 
A

Anne Troy

=SUM(IF(A2:A10=E2:E10,1,0))
After typing it in, hit Ctrl+Shift+Enter

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
A

Anne Troy

Ignore mine. Frank's got it right, I'm sure. :)

Anne Troy said:
=SUM(IF(A2:A10=E2:E10,1,0))
After typing it in, hit Ctrl+Shift+Enter

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Click to expand...
 
B

Bob Phillips

Inverted I think Anne.

Here's an alternative

=SUM(IF(ISBLANK(A2:A10),0,IF(A2:A10=E2:E10,1,0)))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
R

Rod

Thanks to both of you, Bob and Anne, for your help. The
alternative suggested by Bob worked beautifully. We are
using this to analyze student test scores. Again, much
thanks.
 
Top