View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default help with sumproduct

trying to get the following work for data, has: x2 or y2
need to find how many 2's, trying the following, not working:

=SUMPRODUCT(--(RIGHT($T$123:$T$1055,1)=$BJ$7/10))

bj7 has: 20

thanks