text for numbers

B

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
 
L

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
Click to expand...

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
 
Top