Thread: How to ignore #DIV/0! in Sumproduct formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeds Deeds is offline
external usenet poster
  
Posts: 113
Default How to ignore #DIV/0! in Sumproduct formula
Below is my formula...there are #DIV/0! in the data set...(I can't remove).
I want to exclude them in the formula. Basically...how to I exclude the
#DIV/0! in the following formula? Thanks in advance...

=(SUMPRODUCT((Main!$H$2:$H$95100)*(Main!$I$2:$I$9 5-Main!$H$2:$H$95)/(Main!$I$2:$I$95)0.5))
Reply With QuoteReply With Quote