March 26, 2017 at 8:35 PM #1 Hi Forum!Here's the situation:[ATTACH=CONFIG]71968[/ATTACH] Code =sum(s6:s7) returns zero, could it be possible that excel returns 1200w ?Thanks!
March 27, 2017 at 3:18 AM #2 Re: SUM with lettersTry this array formula=SUM(IF(ISNUMBER(SEARCH("w",S6:S7)),SUBSTITUTE(LOWER(S6:S7),"w","")+0))&"w"put this on a cell then press F2 button to open the formula then hit/press all together CTRL+SHIFT+ENTER