Hi,

Sorry for the newbie question, but from my lurks the --() operator seems to
be important and I can't figure out what it's supposed to do. Does it have
something to do with array functions?

Excel for Mac 2004 doesn't have -- in its help index anywhere I can find.
You can't google on punctuation so I'm helpless. If there's a (good) FAQ
posted somewhere please direct me.

TIA,
Matt


On 12/13/04 4:07 PM, in article , "Arvi
Laanemets" wrote:

Hi

=SUMPRODUCT(--(LEFT($C$5:$C$149,6)=$D168),T$5:T$149)


Arvi Laanemets


"Ken Goodwin" wrote in message
...
I would like to select the first 6 characters out of
the 'range' of a SUMIF(range, criteria, sum_range) and
check them against the criteria. Is that possible? As an
example: I tried =SUMIF(left
($C$5:$C$149,6),$D168,T$5:T$149) which does not work. It
is looking for a range of cells for the range.

Ken