View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Smith Karen Smith is offline
external usenet poster
 
Posts: 45
Default SUMPRODUCT Question

I'm trying to use this formula, but its not working, what am i doing wrong?

=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)