Left and Sumproduct

A

Alexball

Hello,

I want to cross check some numbers. Since I only want compare each
number with the first 7 characters of all cells I tried like this:

=sumproduct((left(E16:E19;7)=G16)*1)

It does not seem to work. Am I able to use left like this on a range??

And if not, how could I do it?

Thanks for your help
Alex
 
B

Bob Phillips

Works fine for me, counts them as expected.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top