Running total in Excel with AI

Running total in Excel with AI
Last Updated on 05/06/2024
Reading time: 2 minutes

Do you know you can perform Running Total in Excel without writting a formula? An internal does the job for you.

Running totals in Excel help track cumulative sums easily. They're great for spotting trends and patterns quickly. They simplify complex data, making analysis and forecasting easier.

Doing a Running Total with AI

AI is everywhere, even in Excel. It helps with data analysis, predictions, and automating tasks. Excel's AI features make work easier and more efficient. There are a lot of tools that use AI in Excel, like FlashFill.

To perform a running total without writing a formula, Quick Analysis tool is the solution. Quick Analysis tool is the option that appears when you select a range of cells. If you don't have this option, go to File > Options > General > Show Quick Analysis Options on selection.

Option Show Quick Analysis

But, according to the orientation of your data, you will not used the same option.

  1. If you're data are presented horizontaly
  2. Select the range of cells that contain the values for your calculation.
  3. Click on the Quick Analysis options
  4. Go to Totals tab
  5. Select the option Running total in blue
Running total with AI horizontaly

Notice that the formula fixes one cell while leaving the other unfixed.

  1. If you're data are presented vertically
  2. Select the range of cells that contain the values for your running total.
  3. Click on the Quick Analysis options
  4. Go to Totals tab
  5. Click on the right arrow to open extra options
  6. Select the option Running total in yellow
Running tatal without formula with quick analysis tool

Is this the best technique?

If you are a beginner, for sure this tool will help you a lot. But it is not the best solution if you must perform this calculation over a large range of cells.

In fact, with this solution, you reused the same first cell many times. For instance, the cell G2 is used in each formula.

The best solution is to use the formula explained in this article. Like that, you only have 2 cells to add. This is better to save a lot of resource system.

Second formula for a running total

Leave a Reply

Your email address will not be published. Required fields are marked *

Running total in Excel with AI

Reading time: 2 minutes
Last Updated on 05/06/2024

Do you know you can perform Running Total in Excel without writting a formula? An internal does the job for you.

Running totals in Excel help track cumulative sums easily. They're great for spotting trends and patterns quickly. They simplify complex data, making analysis and forecasting easier.

Doing a Running Total with AI

AI is everywhere, even in Excel. It helps with data analysis, predictions, and automating tasks. Excel's AI features make work easier and more efficient. There are a lot of tools that use AI in Excel, like FlashFill.

To perform a running total without writing a formula, Quick Analysis tool is the solution. Quick Analysis tool is the option that appears when you select a range of cells. If you don't have this option, go to File > Options > General > Show Quick Analysis Options on selection.

Option Show Quick Analysis

But, according to the orientation of your data, you will not used the same option.

  1. If you're data are presented horizontaly
  2. Select the range of cells that contain the values for your calculation.
  3. Click on the Quick Analysis options
  4. Go to Totals tab
  5. Select the option Running total in blue
Running total with AI horizontaly

Notice that the formula fixes one cell while leaving the other unfixed.

  1. If you're data are presented vertically
  2. Select the range of cells that contain the values for your running total.
  3. Click on the Quick Analysis options
  4. Go to Totals tab
  5. Click on the right arrow to open extra options
  6. Select the option Running total in yellow
Running tatal without formula with quick analysis tool

Is this the best technique?

If you are a beginner, for sure this tool will help you a lot. But it is not the best solution if you must perform this calculation over a large range of cells.

In fact, with this solution, you reused the same first cell many times. For instance, the cell G2 is used in each formula.

The best solution is to use the formula explained in this article. Like that, you only have 2 cells to add. This is better to save a lot of resource system.

Second formula for a running total

Leave a Reply

Your email address will not be published. Required fields are marked *