Thread: what is wrong with this formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_2_] Norbert[_2_] is offline
external usenet poster
  
Posts: 31
Default what is wrong with this formula
=SUMPRODUCT((A1:A21=D1)*(B1:B21),(F1:F7))/SUMPRODUCT(--(A1:A21=D1),--(B1:B21))

results in #VALUE!

#WHY?


Reply With QuoteReply With Quote