Left and Sumproduct

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

Works fine for me, counts them as expected.

--
HTH

Bob Phillips

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

"Alexball" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Alexball
> ------------------------------------------------------------------------
> Alexball's Profile:
http://www.excelforum.com/member.php...o&userid=37072
> View this thread: http://www.excelforum.com/showthread...hreadid=569808
>