If you are happy with the formula Excel has created for you, you can press Enter to complete the process (note that you won't get this option if you used the keyboard shortcut).Īt this point it is worth noting that the SUM formula created by Autosum includes the empty cell in B7. It will then wait for you to press Enter (or Escape if the formula is incorrect): ( Tip: You can also press ALT+ = (on Windows) or Option+ Command+ = (on Mac) as an alternative to clicking the Autosum button on the toolbar)Įxcel will automatically find the range of data in the column above where you clicked, and will create a SUM formula that will add up those cells. Next, click the Autosum button, which looks like this: Here is an example of how use Autosum to add up the cells from B2:B6.Ĭlick in a cell in the column below the range you want to add up (or to the right of the range if your data is in a row rather than a column). Autosum example one - add up the cells in a column of data With Autosum, Excel will automatically add up a range of cells for you, and place the result in a nearby cell.Īutosum has been around a long time, and will work in all recent versions of Excel, including Excel Online (part ot the Office365 Suite) and versions on the Mac. It is often faster than creating a formula by hand, especially when you have a large amount of data to add up. Autosum is a powerful feature that can save you time if you need to add up cells or columns of data quickly.
#Sum formula in excel for mac how to
This lesson explains how to use Autosum in Microsoft Excel.
0 kommentar(er)
