Thread: Sum if match any six numbers
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Sum if match any six numbers
Hi,
Perhaps this:
=IF(SUMPRODUCT(--(LEN(G2:G5836)=6)*(ISNUMBER(G2:G5836)))=1,I2:I5836 ,0)
Array entered.
Regards - Dave.
Reply With QuoteReply With Quote