Thread: Sum-if-product
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve[_4_] Steve[_4_] is offline
external usenet poster
  
Posts: 184
Default Sum-if-product
Hi. Does anyone see anything wrong with this formula? It returns an
#N/A and I have no idea why?! Thanks!

=SUMPRODUCT(--(MPD!$B$2:$B$18000=I1),MPD!CE2:CE18000,MPD!$CD$2:$ CD
$18000)

Reply With QuoteReply With Quote