I'm trying to use the correlation function in analysis toolpak but I keep getting "INPUT RANGE CONTAINS NON-NUMERIC DATA". I've used the =SUMPRODUCT(--NOT(ISNUMBER(range))) function for the columns I want to check, and all columns I want to use have turned up 0 but unfortunately I am still getting "INPUT RANGE CONTAINS NON-NUMERIC DATA". Ideas?