Sumproduct
 

I need to the count the number of times a value, represent in column B1 in
sheet 1 appears in the range H1:h15000 in another worksheet

Thanks

ce

Sumproduct
 

Hi, Curtis.

Your question isn't too clear, but it sounds like you can use COUNTIF, since
you only have 1 criteria:

=COUNTIF('Sheet2'!H1:H15000,'Sheet1'!B1)

If that is not what you are looking for, please provide better details.

Jason

"Curtis" wrote:

I need to the count the number of times a value, represent in column B1 in
sheet 1 appears in the range H1:h15000 in another worksheet

Thanks

ce