Thread: sumproduct with multiple tab ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck[_3_] Chuck[_3_] is offline
external usenet poster
  
Posts: 17
Default sumproduct with multiple tab ranges
i forgot to add that in most occassions

$D$33:$D$46 some of the cells maybe empty
K$33:$K$46 some of the cells maybe empty

cheers

Reply With QuoteReply With Quote