| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate to total individual lines
How do I set up excel to calculate individal lines consistently to where the
total of the previus line calculates automatically. I don't want a total sum for the entire column but I want each item to total so that it appears that I am adding each line item to the other. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate to total individual lines
hi, not sure can help, but would still need more of an example. maybe
someone else can pick it up.. thanks "Curious" wrote: How do I set up excel to calculate individal lines consistently to where the total of the previus line calculates automatically. I don't want a total sum for the entire column but I want each item to total so that it appears that I am adding each line item to the other. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate to total individual lines
Assume you have numbers in A1:D10
In E1 enter =SUM(A1:D1) In E2 enter =SUM(A2:D2) + E1 Copy down to E10 Gord Dibben MS Excel MVP On Tue, 17 Jul 2007 16:42:01 -0700, nastech wrote: hi, not sure can help, but would still need more of an example. maybe someone else can pick it up.. thanks "Curious" wrote: How do I set up excel to calculate individal lines consistently to where the total of the previus line calculates automatically. I don't want a total sum for the entire column but I want each item to total so that it appears that I am adding each line item to the other. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Individual Grid Lines | Charts and Charting in Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
Hybrid Mode
