On 16/06/2011 23:35, joeu2004 wrote:
On Jun 16, 7:46 am, wrote:
Sorry, my bad. I should have said how many numbers from
set B occur in Set A, not which numbers match in value
and postion.

I'm sorry, but that is exactly what you said the first time -- well,
the second time ;-).

On Jun 16, 5:18 am, wrote:
Sorry, I should have said, how would I write a formula
that would tell me how many numbers from set B match
numbers from set A.

=SUMPRODUCT(--(COUNTIF(A1:A1000,B1:B30)0))

ITYM

=SUM(COUNTIF(A1:Z1,A3:Z3))

Entered as an array formula Ctrl-Shift-Enter

Regards,
Martin Brown