View Single Post
  #1   Report Post  
anand
 
Posts: n/a
Default sumproduct external reference#2

Similar to previous query. Is there anyway to include an operator in an
external reference to a sumproduct formula.

For example, if the formula is =sumproduct((A1:A10=A12)*(B1:B10=B12))

is there any way to have <6 in A12 or 8 in B12? I have figured out how to
include multiple single values but not sure if an operator as described can
exist in a reference cell (probably not since it doesn't seem to work; but is
there a way to do it?)

thanks

anand