Thread: Sumproduct (probably easy) question
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith R Keith R is offline
external usenet poster
  
Posts: 55
Default Sumproduct (probably easy) question
To all who contributed, a mighty thank you. My final formula turned out to
be:

=SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C2)*1,('Raw
Data'!$B$2:$B$30000=K$1)*1)

Best,
Keith


Reply With QuoteReply With Quote