Countif formula

[Excelnoobisme]

Hi,

In cell A1 to A10 i have a set of word. In cell B1 to B1000 i have another list of number.

im trying to find the number of count of number in A1 to A10 that appear in B1 to B1000.

right now this is my formula:

C1=countif(B1:B1000,A1)+countif(B1:B1000,A2)+countif(B1:B1000,A3)+...

Im want to ask is there any shorter way of formula to do it?

 

[Richard Schollar]

=SUMPRODUCT(COUNTIF(B1:B1000,A1:A10))

should be one way