=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")))