Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.

Calculate sporadic totals in Excel easily using this technique. Having intermittent cells and blank cells in Excel makes calculating the sum of intermittent cells tedious.

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Calculate the expected annual return of your portfolio in Microsoft Excel by using the value and expected rate of return of each investment.

Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.