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


--
Alexball
------------------------------------------------------------------------
Alexball's Profile: http://www.excelforum.com/member.php...o&userid=37072
View this thread: http://www.excelforum.com/showthread...hreadid=569808

Left and Sumproduct
 

Works fine for me, counts them as expected.

--
HTH

Bob Phillips

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

"Alexball" wrote in
message ...

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