View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgkgmg bgkgmg is offline
external usenet poster
 
Posts: 40
Default text for numbers

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