Please share with us where ideas like that come from.
Sumif is, as its name indicates, supposed to return a sum. Sums are almost
always numbers.

HTH. Best wishes Harald

"formula1" skrev i melding
...
how can I return the text value of a cell useing"sumif" formula