Thread: Sumproduct
View Single Post
  #2   Report Post  
Johannes
 
Posts: n/a
Default

spaces... just leave them out... might have an additional meaning that i'm
unawere of though


"wal50" schreef in bericht
...
I'm sure this has a simple answer but I'm missing it.
In examples like this one:
=SUMPRODUCT(--(A1:A100="Apr 04"),--(C1:C100="New"),E1:E100)

What do the dashes (--) mean.

thanks