Quote Originally Posted by Arismar
Set profiledata to $A$2:$FL$13. The mistake is to include the line containing the column names. In this case the function SUMPRODUCT will include cells containing the values ​​of the first row, the row containing the column names, resulting in an error. Because the value of it is invalid to the function.
No, you are wrong there. If he had been using the * operator then he would need to avoid the column headers, but as he is using -- there is no need.

His problem was that he was also using the -- on the range to be summed, --(INDEX(profiledata,,47), and as there were blanks it there it tried to coerce a space to a numeric value, hence the #VALUE.