SUMPRODUCT?

N

nastech

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

Bob Phillips

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

--

HTH

Bob Phillips

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

nastech

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.
 
Top