Learn Excel Episode 241: Old Accountant's Trick
Today, I am appearing at the IMA Continuing Education Workshop in Kent Ohio. There will be a few hundred serious accountants in that room with me today, and most of them will know this trick. Today, we have a spreadsheet where someone added manual subtotals to the worksheet. Rather than building a formula to point just to the totals, there is a cool trick that uses a bit of algebra to solve the problem. Episode 241 will show you how.