What was the formula you used?

Len wrote:

<<snipped

In this case, before applying subtotal function, I 've tried to use
replace function to change error cells "#N/A" contains formula into
text or value cells "0.00" but it fails, is there any other way ?

Regards
Len

--

Dave Peterson