Thread: Can SUMPRODUCT be made to ignore text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thanks thanks is offline
external usenet poster
  
Posts: 48
Default Can SUMPRODUCT be made to ignore text
Hi
My Sum range occasionally has text included in it, is there a a way to make
sum product ignore the test when evaluating?

Reply With QuoteReply With Quote