I wanted to know if the SUMIF function was capable of returning a text value for the sum range. My range is a text value (a typical entry: M123456), and my criteria is a text value (a typical entry: M123456). I want my sum range to return the slang name that I use to refer to the parts (typical entry: Delay Line). Thanks for the help.