| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Formulas
Adding several cells and then subtracting several cell from that total, and
showing the result in another cell? -- LP051354 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating Formulas
=SUM(K1:K3)-SUM(K7:K9)
Put the above formula in "another cell". Add's cells K1:K3 and then subtracts from that total the sum of cells K7:K9. "Lucille" wrote: Adding several cells and then subtracting several cell from that total, and showing the result in another cell? -- LP051354 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating Formulas
Lucille
Assuming cells with numbers are A1:A10 in B1 enter =SUM(A1:A10)-SUM(A2,A5,A6,A9) Gord Dibben MS Excel MVP On Wed, 26 Apr 2006 11:39:01 -0700, Lucille wrote: Adding several cells and then subtracting several cell from that total, and showing the result in another cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Linear Mode
