Table of Contents
Calculating a conditional running total in Excel refers to the process of summing up a series of numbers based on a specific condition or criteria. This can be achieved by using the SUMIF or SUMIFS function in Excel, which allows you to specify a condition or multiple conditions to be met before the sum is calculated. This can be helpful in situations where you want to keep track of expenses, sales, or any other type of data that is dependent on certain conditions. By using this method, you can easily calculate and update the running total as new data is added, providing a more accurate and organized representation of your data.
Calculate a Conditional Running Total in Excel
Often you may want to calculate a running total of values in a column in Excel that is conditional on the values in some other column.
The following example shows how to do so.
Example: Conditional Running Total in Excel
Suppose we have the following dataset in Excel that shows the total sales made by some company on various days:
Suppose we’d like to calculate a running total of sales that restarts on each new day.
First, we can enter the first value of sales in column C:
Next, we can use the following formula to calculate a running total of sales that restarts on each new day:
=IF(A3=A2, C2+B3, B3)
This formula checks if the current date in column A is equal to the date in the previous row.
If the dates match, then the sales from the current row is added to the sales from the previous row.
If the dates don’t match, then the sales from the current row is used as the new starting amount for sales.
The following screenshot shows how to use this formula in practice:
Column C shows the running total of sales for each day.
Notice that the running total of sales in column C restarts for each new day in column A.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I calculate a conditional running total in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-calculate-a-conditional-running-total-in-excel/
stats writer. "How can I calculate a conditional running total in Excel?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-calculate-a-conditional-running-total-in-excel/.
stats writer. "How can I calculate a conditional running total in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-calculate-a-conditional-running-total-in-excel/.
stats writer (2024) 'How can I calculate a conditional running total in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-calculate-a-conditional-running-total-in-excel/.
[1] stats writer, "How can I calculate a conditional running total in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I calculate a conditional running total in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.