How to Calculate Cumulative Income in Excel
Keeping a cumulative income on the Microsoft Excel spreadsheet program is not as hard as it seems. With a little computer knowledge, you can easily enter the data required to create a spreadsheet that stores the cumulative totals of income in a column or row. The cumulative income is the value of an entry which is automatically added to the previous entries in a column or row. The number of columns you use is based on your needs and requirements.
Other People Are Reading
Instructions
-
-
1
Open Excel. Click "File" and select "New." Move the cursor over "File" again to display the menu again, then click "Save." Name the new spreadsheet.
-
2
Enter the date the income was received into first column labeled cell "A1," then enter the date the next income was received into cell "A2." Continue using the "A" column to enter the date you receive the income.
-
-
3
Move to column "B" to begin entering the income you want to cumulatively total. Add the income beside the date it was received, starting with cell "B1," then moving down column "B."
-
4
Create an abstract reference, using the first cell of column "C." Use this cell to keep the cumulative total of column "B." Using this as an example, column "C" will be used to keep the cumulative income. Enter "=SUM($A$1:B1)" into column "C." Use the "$4$1" notation in all the remaining cells, which specifies the beginning of the cumulative income.
-
5
Move the cursor of the cell you just entered data into. Select every cell in the cumulative income column that matches the data in the data columns. Perform this task when you hold shift and click on the last cell of the column, or hold the shift key and press the down arrow until it reaches the last data cell. Using the example above, you entered data in ten cells in column "B," then "C1" through "C10" cells would be selected.
-
6
Enter the same formula into the remaining cells by moving the cursor up to the "Edit" menu at the top of the page. Display the "Edit" menu and move the cursor to "Fill," then click on "Down." Selecting this will automatically copy the formula entry from the first cell without changing the "$4$1" part of the formula, but the "B1" part of the formula will change with each cell.
-
1
Tips & Warnings
Enter in additional rows or columns as you need them by using the "Insert" menu at the top of the page.
Add a name to each row by labeling the first cell and start entering the data into the second row of each column.
The cumulative income is totaled in column "C," so do not use this column for anything other than cumulative income totals. It can add something into the total that is not income.
References
- Photo Credit Jupiterimages/Photos.com/Getty Images
