How do you use Excel sumproduct to return text?

Answer by  Phil28 (379)

You do not. Sumproduct multiplies the lines of arrays and sums up the results. You have to use other functions to create texts depending on the results. You could for example write a function that writes "the sumproduct is below the threshold" through an IF function. You could also do lookups and such that return text based on results.

Answer by  Minelli666 (38)

You need to wrap your sum or product function into the CONCATENATE function. This way the result returned by the sum or product function will be transformed to text. =concatenate(sum(a1;b1;))

Answer by  BrokenWits (382)

Click on the cell, and type =SUMPRODUCT(Values1 * Values2 * Cell). The value will be returned in the cell or cells.