View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Calc RSQ and exclude zeros

You want to exclude entries when BOTH x and y are 0? When either is 0?
Given the nature of the RSQ function this might not make much sense...

But anyway, just replace J11:AG11 with IF($J11:$AG11<0,$J11:$AG11) in
your formula.

HTH
Kostis Vezerides