how to enter simple list and sum

using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a 
cell with the sum of these values?

if the list would look like this
0.58
-1.22
1.79
-0.56
-0.92

the output would look something like
0.58   0.58
-1.22 -0.64
1.79   1.15
-0.56  0.59
-0.92 -0.33


0
johnj700 (1)
5/16/2007 3:34:13 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
1118 Views

Similar Articles

[PageSpeed] 33

John

In B1 enter  =A1

In B2 enter  =B1+A2

Copy down to B5


Gord Dibben  MS Excel MVP

On Wed, 16 May 2007 06:34:13 +0300, "John" <johnj@multipl.es> wrote:

>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative numbers and then create a 
>cell with the sum of these values?
>
>if the list would look like this
>0.58
>-1.22
>1.79
>-0.56
>-0.92
>
>the output would look something like
>0.58   0.58
>-1.22 -0.64
>1.79   1.15
>-0.56  0.59
>-0.92 -0.33
>

0
Gord
5/16/2007 4:11:37 AM
Reply:

Similar Artilces:

Lump sum calculation
Does any one know what function (PMT - PPMT- PV- FV) I have to use the get my results? I want to have 18 years from now the amount of $70,000 If the interest rate will always be 12% I want to make only one payment new. Can any one help me find the function? I couldn't do it by my self, I need your help. Thanks Joe Hi Joe! Try: =PV(12%,18,0,70000,0) Returns: -9102.77130820508 The negative reflects a payment out of 9102 in return for a payment in of 70000 You could negate the function or negate the 70000 if you want a positive sign but in general terms life is less confusing if you fol...

Heirarchical lists
Is it possible in Excel, either through Combo Boxes in VB or the Dat Validation method to do a hierarchical list selection (List tree)? Fo instance, if I have a cell, and when I click on it, the user can selec one of several colors, and then when a selection is highlited (o clicked) it brings up another list next to the original list of foo items, and then depending on that selection, another list of eatin utencils (this is a silly example, but I think it communicates m question). Further, no matter what option is selected from the firs two lists, it brings up the same list for the next selec...

Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered into the Work field for a task, that task's Actual Work is updated to the same value entered in the Work field. This happens to multiple resources, but only on some of their tasks and not on others. For example, for the weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell in the Resource Usage View) for a given task also appears in the "actual" cell. The tasks are setup up differently. Some are Fixed Work, some are Fixed Duration. I believe all have the e...

Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if I enter 10 it is put in as .1 500 is entered as a 5 Thank you Mary Mary, Goto Tools>Options and on the Edit tab you should see The Fixed Decimal Places box checked. Uncheck it. -- HTH RP "maryu" <maryu@discussions.microsoft.com> wrote in message news:65C0E0FB-43F3-4F34-8A86-FBA3F02EC9B1@microsoft.com... > If I enter a number into a cell it is put in like a decimal. For example, if > I enter 10 it is put in as .1 500 is entered as a 5 > Thank you > Mary ...

two lists
I have two lists in separate worksheets. The data is almost identical. There is a column for ID and a column for a post code. I need to be able to put all the data into one sheet with three columns. One will list the the IDs and the others will put the two postcodes next to each other. Unfortunately, some IDs only appear in one sheet, some in the other and some are in both. So I will have some records complete and some partial complete. I have tried to use a look-up but I have confused myself. help! bazblazer, I'm not sure I've actually heard a question. I've made an example. ...

Use Excel for todo lists?
Anyone use Excel for todo lists? If yes..... any add ons worth getting for that purpose? Google returns many hits for "Excel to do list" Vaya con Dios, Chuck, CABGx3 <me@privacy.net> wrote in message news:vchtt05jj2a09pqdej484eu27gaq51oo2h@4ax.com... > Anyone use Excel for todo lists? > > If yes..... any add ons worth getting for that purpose? ...

Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing wrong.....Here is the summary of my problem. I have a form named 'frm_EfficiencyStats' and a subform within the form named 'qry_Total hours subform' (the subform is based on a query). The form contains a text box (for date) which is bound to a table 'tbl_EfficiencyStats'. I would like to be able to enter a date in the text box on my form, and display the records in the subform based on the date I entered in the text box. The subform will only pull records from my table based on the date. Here are th...

getting consolidate list of "follow up" items
Dear All, I would like to get a consolidated list of items (sent and received mails)that have matured - i.e. whose follow up time is up. I have the habit of tagging a sent mail (after actually sending) for follow up. Similarly, mails received are also tagged for my further action (for follow up). Would appreciate a consolidated follow up report generation way - rather that opening each folder and looking for mature items (i.e. red). Thanks in advance. Sanjay ...

Simple reports not available?
I am trying to get what I thought would be an easy report, with no luck... I need a report that: I can see who my top vendors are by fiscal year by dollar amount in descending order. Without it being a million pages (figuratively speaking). Also want the same report for my top customers, showing who has spent the most with us over the fiscal I choose to run it. Is this possible? any ideas, or anyone know a place I can find good FREE templates? Thanks Paul Use Smartlists. -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com 4/3/2007 3:27:02 PM Paul J wrote...

how to enter simple list and sum
using excel 2002 with an xp sp2 system how would I enter a simple list of positive and negative numbers and then create a cell with the sum of these values? if the list would look like this 0.58 -1.22 1.79 -0.56 -0.92 the output would look something like 0.58 0.58 -1.22 -0.64 1.79 1.15 -0.56 0.59 -0.92 -0.33 John In B1 enter =A1 In B2 enter =B1+A2 Copy down to B5 Gord Dibben MS Excel MVP On Wed, 16 May 2007 06:34:13 +0300, "John" <johnj@multipl.es> wrote: >using excel 2002 with an xp sp2 system >how would I enter a simple list of positive and negative...

Change Discount List
I'm trying to change our discount lists (about 21, applied to over 40 Products & 2 Price Lists) from percentage to $. Can I do this on-the-fly? It doesn't appear so. If not, should I (in order): 1 Create New Disc List 2 Associate new Disc List with appropriate Products 3 Delete Old Discount Lists Has anyone done this before? This is going to be a HUGE project, and am looking for any tips I can get. Thanks. ...

Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
Hello, I have an ePM user asking why if he enters a project task in PWA does it not check the resource max units allocation the same way as when he enters a task in Project Professional. For example: You have a project where resource A is 50% allocated. When you create a task in Project Professional for this resource, the resource allocation is set to 50%. Create a task under the same project in PWA, submit and approve the task. Open project professional and view the task information for the task entered in PWA, why is the resource allocation set to 100% instead of 50% set for th...

Enter formula by code.
Hi All can anyone help. I cant seem to get this to work. I keep getting run time error 1004 application or object defined error. Public Sub TLIdentify() finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 = "=IF(OR(RC[-38]>0,RC[-32]>0,RC[-26]>0,RC[-20]>0,RC[-14]>0,RC[-8]>0,RC[-2]>0),VLOOKUP(RC4,'Team Summary'!R4C3:R16C4,2,0),"")" End Sub -- Regards and Thanks for any assistance. Francis Brown...

Help needed weve been grey listed
Hi any help here will be super, basically weve been blacklisted by virgin and aol, just looking in system manager under smtp connections and found an ip address but no user? i traced the ip (but didnt write it down) to china, now trust me nobody works in china from here in the uk so this must be the source of the spam and why we are starting to get black listed. IN the properties of the smtp server anonymous is not tick and basic and intergrated authentication are ticked. On the firewall i ca see about 5 connections to exchange through port 25 some in china japand and germany but how are they ...

Missing something simple in DCount
I need help. I am trying to use DCount. I need to count occurances. my formula is Expr1: DCount([RETURNS_05],"Test"," > 0 And < 50"). I keep getting # Error as my result. Please advise Below is an example of my table. The real table has 80,000 zipcodes, many repeated. Zipcode Returns 11111 23 12345 46 11111 200 33424 20 31111 32 11111 25 I need to count how many times returns >0 and <50 occurs. Please advise. You need: - quotes around the field name to count; - to specify a field name in ...

Common Contacts List
Hi Outlook 2003 We have just installed a server in our work. There are 8 computers connected to it, each with Outlook. What we would really, really like, is to have just 1 Contacts List which is accessable to all users via Outlook. Preferably, this list would live on the server. Thanks - Dave. Is the server Exchange server? If not, is it configured for LDAP? If the answer to both is No, then you would need a 3rd party program to share contacts. See http://www.slipstick.com/OUTLOOK/share.asp -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Ex...

membership list
Friend of mine manages the membership list for a club, about 500 or so, using Excel as the program. It contains the usual; names, addresses, phone numbers, skill levels. Presently there are five levels. As can be expected, the list constantly changes with members moving to different levels, coming or leaving the club. There has to be periodic reports to the executive of the numbers in each category. I suggested adding a couple of blank lines after each category and using the CountA function to count the number of members in each category but I'm not very good at Excel either. The...

Simple storage tool(s)
I've been looking at several tools to make our Exchange storage easier. One of the first things we'd like to do is bring in a whole bunch of old Public Folders (that contain old mail etc etc), from an Exchange 5.5 environment into our 2003. Just pure data. We could copy to .pst files and import from them. That's a lot of work. I don't want to run a mixed environment (and we're in 2003 native already, so that's not a option anyway). EMC(Veritas), Symantec etc etc all have nice tools for putting Exchange data in 'vaults'. But most of these tools are so eno...

Add a drob down list box to the tool bar?
I'm working with Microsoft Visual C++ 6.0. The software I'm working on has a main window that brings up other windows when you click on various buttons on the tool bar. I need to add a drop down list box to the tool bar to select between 2 different modes. How do I go about adding a drop down list box on the tool bar? -Lee Browning Don't you mean a combo box? There are good samples in toolbar section of codeguru. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "Lee ALICEngineer" <LeeALICEngineer@discussions.microsoft.com> wrote in message news:9620EAA...

image list
hi, i want to list images using a list box. can i use CImageList for .gif images? anu ...

Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I have to enter is the numbers? It's one of the options you can specify. In Excel 2007, it's: Excel Options...>Advanced>Automatically insert a decimal point Regards, Fred "Julieanne" <Julieanne@discussions.microsoft.com> wrote in message news:3AABE398-3B77-4ACD-8938-05ED7F5CC58E@microsoft.com... > What is the formula to have Excel automatically enter the decimal so all I > have to enter is the numbers? ...

Can not use contact list in Mail Merge
When trying to import a contact list to use in Mail Mrge, from Microsoft Outlook, I get the following message: " Either there is no default mail client or current mai client cannot fullfil the messaging request. Please run outlook and set it as the default mail client" I did that and I get the same messagE. Mike I don't understand what you are trying to do. List the precise steps. There is no need to import a list from Outlook for a mail merge. Your Outlook Contacts can serve as a data source for a merge. -- Russ Valentine [MVP-Outlook] "Mike E" <epsteinmb@wor...

Sum of all combinations
I have 7 categories, each category has 5 possible scores. I want to calculate the sum of each possible combination. Is there a way to do this in Excel? My grid looks like this: JobKnowl 15 12 9 6 3 CallAcc 15 12 9 6 3 CallQual 15 12 9 6 3 JobAcc 5 4 3 2 1 IPSkill 10 8 6 4 2 Attend 20 16 12 8 4 Punct 20 16 12 8 4 "cursednomore" wrote: > I have 7 categories, each category has 5 possible scores. > I want to calculate the sum of each possible combination. > Is there a way to do this in Excel? I would write a VBA subroutine. But .... > My grid looks like this: > JobK...

Drop Down List Question #2
I have a drop down list from 5 cells merged together so as I can read the length easier, I know I cant select a field from merged cells, is there any way that when I select my choice I can get cells either side of my selection A B F 12 Jan Apples $12.00 17 Feb. Pears $14.00 I have B Column as my range in drop down , how can I get the date and price to move as well? What I want to do is select Pears and the date, Item and price would move to say K L P Columns if my drop down list was in L column...

How do I stop dates from being entered everytime I enter a number
Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to the next cell and it automatically puts in may 9 . I have tried putting in general in formatting cells and it still does it. can someone help before I shoot this pc out the window? I am making a population pyramid with males and females and their ages. Thanks, Kicking and Screaming You can precede your entry with a single quote... '5-9 ....or format your cells as 'Text'. Hope this helps! In article <64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com>, Kicking and Screaming <Kicking and...