Thread: Sumproduct not works
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kashish kashish is offline
external usenet poster
  
Posts: 18
Default Sumproduct not works
In below formula in place D1 it should come "B" but its not work why?

A B C D

1 A 2 =SUMPRODUCT(--($A$1:$A$5=C1),--$B$1:$B$5)
2 B
3 C
4 D
5 E

Reply With QuoteReply With Quote