Thanks! curious what the "double negative" is for in the equation / "--"
keep thinking my attempts are wrong cuz don't understand..
also wonder if needs to be array? (correct term?): cntrl-shift-enter?
seem to get same output, whether use cntrl-sh-enter, or not.


"Bob Phillips" wrote:

=SUMPRODUCT(--(LEFT(BA80:BA1098,1)="x"),--(E80:E1098<"x"))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"nastech" wrote in message
...
tryig to find way for different column to exclude line that has been
checked,
same line, by placing an "x" in a different column

have equation:
=SUMPRODUCT(--(LEFT(BA80:BA1098,1)="x"))

need something like: not working
=SUMPRODUCT(AND(--(LEFT(BA80:BA1098,1)="x",E80:E1098<"x")))