SUMPRODUCT?
 

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

SUMPRODUCT?
 

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

SUMPRODUCT?
 

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

SUMPRODUCT?
 

No, SP works on arrays, so it doesn't need to be array-entered. For an
understanding of the double unary, see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

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

"nastech" wrote in message
...
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")))