Thread: Sumproduct thru blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSH BAHAL HARSH BAHAL is offline
external usenet poster
  
Posts: 14
Default Sumproduct thru blank cells
What should be the formula to enter a sumproduct formula which can ignore
blank cells or cells with nil values in the identified range ? I have three
set of range.

Reply With QuoteReply With Quote