View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Mod a Formula For Errors

I'm trying to modify this formula so that it does the calculation even if
some of the cells in the ranges do not have "values (N/A or other errors).
Thanks you in advance.

=SUMPRODUCT(--($C$3:$C$216=I3);--($F$3:$F$2160))/COUNTIF($C$3:$C$216;I3)