Thread
:
help with sumproduct
View Single Post
#
1
Posted to microsoft.public.excel.misc
nastech
Posts: n/a
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
Reply With Quote