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
|