Sum Product Quest: include an OR?
hi, am wondering how to modify formula to include an OR item.. thanks
I put the IF prefix, seems to be working..
=IF(AND(ROW()$A$540,ROW()<$A$567),"",
SUMPRODUCT(--(LEFT($AX$56:$AX$1168,1)="x"),--($G$56:$G$1168<"x")))
would like to OR the last part:
--($G$56:$G$1168<"x")
with: $G$7="x",
|