Count Occurances of List Within Another List

[kjacob318]

Hey there,

I have a list in A2:A10 and I want to count the frequency of total occurances the values in this list (A2:A10) occurs within my larger list that is within B2:B2000.

Is there a way to do this with a simple formula, instead of having to do individual counts for my smaller list then summing them?

Any help you can provide is greatly appreciated! Thank you!!

 

[Aladin Akyurek]

=SUMPRODUCT(COUNTIFS(B2:B2000,A2:A10))

should achieve the intended result.

 

[kjacob318]

Great! Thank you Aladin, it worked exactly how I needed!

 

[Aladin Akyurek]

Great! Thank you Aladin, it worked exactly how I needed!

You are welcome.