Thread: Getting #Value error on Sumproduct with non-contiguous cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJ Master AJ Master is offline
external usenet poster
  
Posts: 29
Default Getting #Value error on Sumproduct with non-contiguous cells
I'm trying sumproduct, where one of the arrays is non-contiguous:

SUMPRODUCT(($AB$607:$AB$615=TRUE)*(AY583,BD583,BE5 83,BF583,BG583,BH583,BK583,BL583,BM583))

The result in receiving a #Value error. Any suggestions or workarounds.

Thanks...AJ
Reply With QuoteReply With Quote