View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default 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",