Sumproduct with either text of number format
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
Note: the value in column H could be formated as text or number
Thanks
ce
|