Thread: Sumproduct not works
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Sumproduct not works
SUMPRODUCT calculates a number. "B" isn't a number.
--
David Biddulph

kashish wrote:
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