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
|