CountIF matching cells

[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.

 

[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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100=E1:E100),--(A1:A100<>""))

 

[Anne Troy]

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

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

 

[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)

 

[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.