Glad it's working & thanks for the feedback.
My guess is that you still had some #N/A values or some of the IFERROR functions were returning " ", rather than ""