Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game ... the result—including the Total row—updates accordingly. You could also use the same method with unformatted tables by ...

In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions ... on the target cell where you want the total to appear. Then type = in the cell ...