Countif?

[JTL9161]

(I am simplifying the data to make explaining easier)

I have a table G60:G75. Some with data some with blanks. I then have H60:H75 all with data. I need the sum of the number of times the data in G60:G75 matches the data in H60:H75.

1 5
2 2
3 3
4
4 5

So for the above table the answer I am looking for is 2 as the 2 in G61 = H61 and the 3 in G62 = H62.

Any help will be appreciated
James

 

[Special-K99]

=sumproduct(--(a1:a5=b1:b5))

 

[Fluff]

How about
=SUMPRODUCT(--(G60:G75=H60:H75))

 

[JTL9161]

Thanks you to both. I will give it a try.

 

[Special-K99]

Oops, youll need to change the references in my formula, formula i posted still refers to my test data

 

[JTL9161]

One last tweek. If there are matching blank cells in column H and G I do NOT want them counted. Only cells with data in column G that matches data in column H

 

[Special-K99]

Try =SUMPRODUCT(--(G60:G75=H60:H75))*(G60:G75<>""))

 

[JTL9161]

Thanks...again

 

[JTL9161]

Me again.

I entered =SUMPRODUCT(--($G$60:$G$74=$H$60:$H$74))*(G60:G74<>"") which I thought was correct. An error came up and then suggested changing the formula to =SUMPRODUCT(--($G$60:$G$74=$H$60:$H$74))*(G60:G74<>"") which is the same as I typed in. When I say yes I then get #VALUE . So it suggested the same as I typed and still returned an error.

 

[Fluff]

There was an extra closing bracket in there, try
=SUMPRODUCT(--(G60:G75=H60:H75)*(G60:G75<>""))