text for numbers

[bgkgmg]

I am using SUMIF for returning number values that meet certain criteria.
Now I want to return text, instead of numbers, that meet certain criteria
and am having trouble. Also I do not want a zero to return where there is no
value.
Thanks
Bobby

 

[Lars-Åke Aspelin]

I am using SUMIF for returning number values that meet certain criteria.
Now I want to return text, instead of numbers, that meet certain criteria
and am having trouble. Also I do not want a zero to return where there is no
value.
Thanks
Bobby

Your description is a bit confusing to me.
Please give a real example of what you would like to see for some
typical input data. Also state where you would like the output to be
placed, in one or several cells.

Lars-Åke