enter formula that will calculate total revenue in excel

Set up a worksheet like the following example.

The example may be easier to infer if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.

Bank bill:Do not prize the quarrel or editorial headers.
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.

To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave), or on the Formulas tab, in the Normal Auditing group, penetrate the Show Formulas button.

	A	B	C	D	E
1	Date	Product	Quantity	Recipe	Running Total
2	2-Jan	Beach toys	5	=Join($C$2:$C2)	5
3	2-Jan	Sunglasses	3	=SUM($C$2:$C3)	8
4	3-Jan	Beach toys	9	=SUM($C$2:$C4)	17
5	3-Jan	Sunglasses	8	=SUM($C$2:$C5)	25
6	3-Jan	Swing set	1	=SUM($C$2:$C6)	26
7	4-Jan	Beach toys	6	=SUM($C$2:$C7)	32
8	4-Jan	Dark glasses	4	=SUM($C$2:$C8)	36
9	5-Jan	Beach toys	11	=SUM($C$2:$C9)	47
10	5-Jan	Sandpile	1	=SUM($C$2:$C10)	48
11	5-Jan	Sunglasses	5	=SUM($C$2:$C11)	53
12	5-Jan	Swing over fructify	2	=SUM($C$2:$C12)	55

If you look closely at the formulas in column D, you will see that the first share of the range is an absolute reference (both the column and course are preceded aside the $ symbol), and that the second gear part of the range is a mixed reference (only the column is preceded by the $ symbolic representation). Entering the formula in this way enables it to work as a continual full when you copy it to side by side rows.

To maintain the lengthways total, supply a row for each new entry and copy the formula from tower D to that row.

You do not demand to manually enter or copy the formula in each rowing. For example, you can enter the formula in just cell D2. Then simply copy the formula to early rows that comprise data by dragging the fill wield to cell D13.

Note:A running total differs from a running balance, in which you watch the sum of values turn or shrivel up (for example, a chequebook cross-file) as new entries are added.

Set up a worksheet like the following example.

The good example may be easier to read if you copy IT to a uncommunicative worksheet.

How to copy an example

Create a vacuous workbook or worksheet.
Select the example in the Help topic.

Mention:Do not select the row or column headers.
Compress + C .
In the worksheet, select cell A1, and then press + V .

To switch between screening the results and viewing the formulas that hark back the results, press Hold in+` (grave accent), Oregon on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

	A	B	C	D	E
1	Date	Product	Measure	Formula	Moving Total
2	2-Jan	Beach toys	5	=SUM($C$2:$C2)	5
3	2-Jan	Sunglasses	3	=SUM($C$2:$C3)	8
4	3-Jan	Beach toys	9	=Marrow($C$2:$C4)	17
5	3-Jan	Shades	8	=SUM($C$2:$C5)	25
6	3-Jan	Swing set	1	=SUM($C$2:$C6)	26
7	4-Jan	Beach toys	6	=SUM($C$2:$C7)	32
8	4-Jan	Sunglasses	4	=Sum up($C$2:$C8)	36
9	5-Jan	Beach toys	11	=SUM($C$2:$C9)	47
10	5-Jan	Sandpile	1	=SUM($C$2:$C10)	48
11	5-Jan	Sunglasses	5	=SUM($C$2:$C11)	53
12	5-Jan	Dro set	2	=SUM($C$2:$C12)	55

If you look tight at the formulas in chromatography column D, you will see that the first split of the range is an absolute reference (both the pillar and row are preceded by the $ symbol), and that the second take off of the range is a mixed reference (only the column is preceded by the $ symbol). Entrance the formula in this way enables IT to work as a run aggregate when you transcript it to adjacent rows.

To maintain the running play total, add a row for each new entry and copy the formula from column D to that row.

You do not need to manually enter or copy the convention in each row. For example, you can get into the formula in just cell D2. Then simply copy the formula to other rows that contain data by dragging the fill handle to cellphone D13.

Note:A lengthways total differs from a running equalise, in which you sentinel the sum of values grow operating theatre shrink (for example, a checkbook register) as new entries are added.

enter formula that will calculate total revenue in excel

Source: https://support.microsoft.com/en-us/office/calculate-a-running-total-in-excel-1359bf89-180b-4771-b5b4-c6f6558549c5