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.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

To multiply certain numbers or cell values in Excel, you’ll need to use the * (asterisk; also called "star") operator. To multiply two numbers in Excel, you can type the formula =number1*number2 in ...

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how. Skip to main content ...