How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your ...

Considering how quickly you retrieved up-to-date county data, it’s worth the small hitch. Now, let’s add the population for each county. You don’t have to keep the state values, but for our ...

To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data" and highlight all entries in the single column.