| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i add up 2 x columns separately and also do a minu
i want to add column A (require amount at bottom of page and also in Column C
column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
Could you explain in a little more detail what you are trying to do? It
sounds like you need: Column A Column B Column C Row 1 4 3 A - B = 1 Row 2 8 5 A - B = 3 Row 3 Sum A = 12 Sum B = 8 Sum C = 4 "sierra_louise" wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
You are right in what I need.. How do I do this..
Simple terms please im only a beginner using Excel Thanks GHawkins "GHawkins" wrote: Could you explain in a little more detail what you are trying to do? It sounds like you need: Column A Column B Column C Row 1 4 3 A - B = 1 Row 2 8 5 A - B = 3 Row 3 Sum A = 12 Sum B = 8 Sum C = 4 "sierra_louise" wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
Pretty confusing to me what you require other than a few SUM(range) formulas
and maybe a SUM(range)-SUM(range) Re-post if the above does not help. Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 12:14:02 -0700, sierra_louise wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
In row 3 enter =sum(a1:a2) in column A
Then copy and paste in column B and column C. -- Brevity is the soul of wit. "sierra_louise" wrote: You are right in what I need.. How do I do this.. Simple terms please im only a beginner using Excel Thanks GHawkins "GHawkins" wrote: Could you explain in a little more detail what you are trying to do? It sounds like you need: Column A Column B Column C Row 1 4 3 A - B = 1 Row 2 8 5 A - B = 3 Row 3 Sum A = 12 Sum B = 8 Sum C = 4 "sierra_louise" wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
Sorry if i sound thick, but, how and where do I put the sum ranges?
Like I said earlier, I need SIMPLE TERMS, first time using Excel and Ive been told everyone swears by it... but, it seems so confusing. Please help me out in a IDIOTS GUIDE! Thanks Sierra_Louise "Gord Dibben" wrote: Pretty confusing to me what you require other than a few SUM(range) formulas and maybe a SUM(range)-SUM(range) Re-post if the above does not help. Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 12:14:02 -0700, sierra_louise wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add up 2 x columns separately and also do a minu
From your original description, I have no idea which column is to be added up
and which is to be subtracted. To add single cells enter =A1+B1 To add ranges of cells enter =SUM(A1:A5) which would give a sum of A1, A2, A3, A4 and A5 To subtract single cells you would enter =A1-B1 To subtract ranges you would enter =SUM(A1:A5)-SUM(B1:B5) Where do you put the formulas? Anywhere but in the cells to be added or subtracted. You may want to take a walk through one or more of these......... Some tutorial sites for basics of Excel........ http://www.usd.edu/trio/tut/excel/index.html http://www.baycongroup.com/el0.htm http://office.microsoft.com/en-us/tr...831141033.aspx Gord On Wed, 23 Aug 2006 14:34:02 -0700, sierra_louise wrote: Sorry if i sound thick, but, how and where do I put the sum ranges? Like I said earlier, I need SIMPLE TERMS, first time using Excel and Ive been told everyone swears by it... but, it seems so confusing. Please help me out in a IDIOTS GUIDE! Thanks Sierra_Louise "Gord Dibben" wrote: Pretty confusing to me what you require other than a few SUM(range) formulas and maybe a SUM(range)-SUM(range) Re-post if the above does not help. Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 12:14:02 -0700, sierra_louise wrote: i want to add column A (require amount at bottom of page and also in Column C column B (require amount at bottom of page) but these minus the total in Column C total Column C (which is A minus B) How do i do this.. please help Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
