Learn Excel Episode 727: Building Formulas with Text

Posted in Companies, Podcasts on July 14, 2008

Bill has a worksheet where he's building text references and then hopes to evaluate the resulting SUM function. Instead, I suggest using INDIRECT to add up the three individual cells. Episode 727 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, concatenation