Increment A2 from A1 and A2 Sum #2

I have two cells:
A1 - manual value
B1 - automatic increment  = B1 + A1

How can i make it?
(=error: circular reference)

Note: I have this formula repeated in some lines:
= B2 + A2
= B3 + A3
..

--
Message posted from http://www.ExcelForum.com

0
1/8/2004 8:58:37 AM
excel 39879 articles. 2 followers. Follow

0 Replies
432 Views

Similar Articles

[PageSpeed] 15

Reply:

Similar Artilces:

Duplicate Rows #2
I have exported an Act 6.0 contact database into a .csv excel spreadsheet. It worked perfect! Each contact occupies a single row. However, some of the contacts are duplicates (existing before the export). Is there an easy way that I can remove duplicated rows in a spreadsheet? I know there must be, but how? Thanks "instauratio" <instauratio@discussions.microsoft.com> wrote in message news:2483416E-4698-4BBF-A554-89DFAFA3AAD6@microsoft.com... > I have exported an Act 6.0 contact database into a .csv excel spreadsheet. It > worked perfect! Each contact occupies a singl...

Charting Time #2
Hi I have a temperature graph that I need to chart over time. From 0 to 168hrs but the Log chart in Custom Types gives me even spaces between the times which is not what I want .25mins to 168 hrs? If I was to plot the graph in minutes it would be too vast - huge! Is there any add-ins available to do this type of graph. Thanks -- Kind regards Ann Shaw No add-ins necessary, just use Excel. You can put your data in decimal hours if you want, or enter it as hh:mm format. Don't include text labels in the same cell, or Excel will treat the times as categorical labels. Make an XY char...

Import CONTRACTS into CRM 1.2
Hi everyone. Anybody can tell me how can i import contracts into Microsoft CRM??? The data migration framework does not allow this! Thanks in advance and sorry for my english. Bea. You might try using Scribe Migrate's 90-day license for importing data into Microsoft CRM. Linda >-----Original Message----- >Hi everyone. > >Anybody can tell me how can i import contracts into Microsoft CRM??? >The data migration framework does not allow this! > >Thanks in advance and sorry for my english. > >Bea. > > > >. > Thanks linda, but... what's t...

Server Error in '/' Application #2
After meticulously following the installation instructions included with the MS CRM CD, I have run into the following error that I'm hoping someone can shed some light on: ++++++++++++++++++++++++++++++++++++++++++ Server Error in '/' Application. -------------------------------------------------------------------------------- Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ApplicationE...

Strange characters in Excel #2
A user in my network complains then after working sometime in excel (10-15 minutes) he starts receiving strange characters when typing, like if he presses the S key A will be written or some other special character this at the same time also happens with other keys as well. other products in Office suit runs ok. Now when i connect to his workstation remotely i don't face this problem when typing on his screen via my remote control software (VNC) what can be the problem ? regards See your other post for the reply! "Stingray" wrote: > A user in my network complains the...

not enough memory #2
i open a multiple page file and i cannot access other pages showing a NOT ENOUGH MEMORY message. even though i have 512MB physical memory. what's the solution(s)? After managing to set up OE-QuoteFix on his new PC, Ed reads a message from Josh <printex@cwnet.com>... > i open a multiple page file and i cannot access other pages > showing a NOT ENOUGH MEMORY message. even though i have > 512MB physical memory. what's the solution(s)? Are you running Norton AntiVirus? How much hard drive space do you have? What size is your swapfile? -- Ed Bennett - MVP Microsoft Publi...

Summing multiple tables
I am trying to use a query to sum up multiple tables. When run, it should have like 14 fields with each having a sum total for a table. I have tried doing this up to 3 tables (took a long while), but it didn't work for 4 tables; I just get a blank observation in the query view. So my questions are if there is a way to do this for 14 tables and if this will take up a lot of memory? Thanks, Henry Since each of these tables is independent of the others, you should be using 14 queries. What is the point of doing the summation in a single query? If you are doing this for a report or ...

Advanced Find #2
Issue: The security role has been set so that it read for user. User can still see records created by other users. To recreate Set the security role on core records so that read is only for userr. Apply this role to a user. Do an advanced find. Find in activities: Field: Created by Condition: Does not equal Type:User (here you should only be able to select the current users) Enter go and the list of activities for everyone in the whole organization is return. It is my understanding that this should not occur with the role set with the core record to user. I would expect that there be no...

Sum of all numbers before a blank row
I have an excel file which i have sorted by column 'Ordered Item'. Next to this column is a 'Price' column. The 'Ordered Item' Column may have duplicates. What I need to do is put a subtotal beside each group of 'Ordered Items' (even if they are single items). How would I sum the Prices every time there is a change in the data in column 'Ordered Items'? Ordered Items Price 241 50 241 50 340 25 600 100 600 100 So if the sheet looks like this, how ...

Strange Behavior #2
We are running Outlook 2003 on all our desktops, some of them have started showing the same issue/problem... When you send an email the outbox stays bold until you click somewhere else in Outlook. Does anyone have any idea what is causing this and/or how to fix it? Thanks in advance, Dave I can also confirm (just checked) that the mail in outbox isn't being sent until that click happens. Dave > Dave" <News> wrote in message news:O6LLG9eKFHA.904@tk2msftngp13.phx.gbl... > We are running Outlook 2003 on all our desktops, some of them have started > sho...

aligning dates #2
I have dates in the format yyyy mmm dd. If I use a font like Arial the = days(dd portion) don't line up. How can I align them without using a = fixed width font; maybe via number formatting codes(just a shot in the = dark)? 2004 Sep 01 2004 Jul 01 Vivek -- [Rewrite email id to reply in person] They sure seem to line up for me. If you change the zoom factor to 100% does it look ok? If yes, then maybe this post by Debra Dalgleish will help: You can change a registry setting to prevent this from happening (make a backup copy of the registry first): 1. From the Start button, choose Run...

auto sum will not work
I am new.. I did the tutorials.. I have a new spread sheet and I can not get the auto sum to work. I highlight my column and hit auto sum and it gives me a formula but no total. I pushed enter but I can not figure this out. I'm a dummy. Please help me. Sounds like the cell if formatted as TEXT. Change the cells format to GENERAL then hit function key F2 then hit Enter. -- Biff Microsoft Excel MVP "Soshagayle" <Soshagayle@discussions.microsoft.com> wrote in message news:C059BF57-C602-467E-B480-620A84DBCF15@microsoft.com... >I am new.. I did t...

Intelligent Message Filter ver 2. Not sure if its enabled or even installed correctly.
I recently upgraded to Exchange 2003 SP2. Before doing this I uninstalled IMF ver 1 as instructed. How can I check whether IMF ver 2 was installed correctly with the SP2 and running properly? There is no longer anything in the SMTP protocols in Exchange System Manager that says Instant Message Filter, although there is still the IMF tab in the Message Delivery. Is it possible that the IMF ver2 didn't install with SP2? How can I install and enable it? The only reference I can seem to find refers to ver1. Many thanks in advance. "Barry Johns" <b.johns@carltonpressgroup.com&...

Can't operate 2 separate Office 2004 programs within same network at the same time
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) We have 2 macs networked. Each has its own software of 2004 Office (we just bought and downloaded the second version for the second computer to fix this problem) but the computers will not allow 2 people to work on their computers using the 2 programs. It says someone is already using the program and will not allow the other to access their own version. One computer has both versions, one computer has only the newer purchased version. How can we make this work?? Any help will be appreciated so we can get our work done! Thanks. Victoria &l...

20 Amazing Beautiful Landscape Wallpapers Set 2.exe (7/7)
=ybegin part=7 line=128 size=1593867 name=20 Amazing Beautiful Landscape Wallpapers Set 2.exe =ypart begin=1497601 end=1593867 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n�...

2 bars, 2 axis??
I'm trying to create a graph which shows load factor (one bar) and yield (one bar)for the month, then next to this the same data for the next month and so on. I can create the graph and assign each of the bars to the primary or secondary axis. However this causes one of the bars to sit on top of the other, I want them to sit side by side. Any idea's please? Hi Luke, For a 2 series column chart with a series on each y axis try Jon's example. http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html Cheers Andy Luke wrote: > I'm trying to create a graph which shows ...

Investment Summary on Home Page #2
My investment summary on my Home Page shows some stocks I haven't had for years, and is missing some that I currently own. How can I choose what to display? Thanks -- David Schwartz Commack, NY I just noticed the same thing on my Investment Summary. My Portfolio manager is correct, but the Investment Summary is out of date. Any help out there?? "David Schwartz" <who4ever@optonline.net> wrote in message news:awdLh.18$Bx.6@newsfe12.lga... > My investment summary on my Home Page shows some stocks I haven't had for > years, and is missing some that I c...

Re:Gord Dibben Sum Text
Hi Gord, It works fine writing text in B1, thank you! Now, I've tried to write the text in A1, but then I get that ###value again. Please explain how this formula works, so I can modify it as I wan to. (In my version of excel I have to write ; instead of ,) //Thoma -- Jonsso ----------------------------------------------------------------------- Jonsson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=547 View this thread: http://www.excelforum.com/showthread.php?threadid=27548 Maybe this =SUM(N(B1),-N(A1),N(C1)) -- HTH RP (remove nothere from the ...

Money has stopped working #2
I receive error: Money has stopped working when I try to backup. A search found kb942485 which suggests changing DEP settings. Article is for Vista, won't let me make changes running Windows 7 Ultimate. Money Deluxe has run fine until last few days, problem started after installing newest updates, including Live Essentials 2011. System Restore is out, too many changes since updates were installed. Any suggestions greatly appreciated. Thanks, Dick Lewis In microsoft.public.money, No_Junk_Wanted@Here.com wrote: >I receive error: Money has stopped working when I try to backup. A >se...

Linking workbooks #2
Hi, I have two workbooks, exactly the same, on two different computers and both have to be updated. Updating takes place by two different people. My problem is that when I try to update the one on the other computer, the user has left it on and I get a read only file and vice versa when he tries to update mine. We both need this file at varying times of the day, sometimes at the same time. Is there anyway that I can link these two files so that as I input data or he inputs data, both files are updated? Thank you I am not sure from your comments whether you have one file accessible from two...

worksheet tabs #2
How do you switch between worksheet tabs using the keyboard? Use CTRL+PageUp and CTRL+PageDown. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "llh" <anonymous@discussions.microsoft.com> wrote in message news:988001c3eb38$6ac0ebf0$a301280a@phx.gbl... > How do you switch between worksheet tabs using the > keyboard? In Excel, go to Help and Look at Keyboard Shortcuts "llh" <anonymous@discussions.microsoft.com> wrote in message news:988001c3eb38$6ac0ebf0$a301280a@phx.gbl... : How do you switch bet...

Frank Kabel #2
Hello! I have a doubt that no one can take it off and i'm around and around the problem and because of a part i can't solve it. This is the problem: A B C D Prod. Stock In Out Wine 10 3 6 Fish 13 2 1 What i want to do is to identify the product that has move quantity in or out such as quantity that has been moved, once i solve this problem i think i can do the rest of problem. Can you help me??? Thank you very much!!! Hi not really sure what you mean by 'move quantity'. In your example what would be yo...

Server side rule #2
How do i go about creating a server side rule? Im trying to foward email to a blackberry so if you have any help it would be appreciated On Tue, 16 Aug 2005 11:48:43 -0700, "Ap" <Ap@discussions.microsoft.com> wrote: >How do i go about creating a server side rule? Im trying to foward email to a >blackberry so if you have any help it would be appreciated A server side rule is merely a rule that you create in Outlook that is able to process without a client running because it's got all the components it needs to fire that rule on the server configuration. As for th...

deleted 2 columns by mistake
I have deleted 2 columns of info and have saved - is there anything I can do ! argh! Only if you're on a company network or suchlike that backs it up, otherwise if you overwrite the file, that's it I'm afraid, Sorry, Alan. "Lang8er" <Lang8er@discussions.microsoft.com> wrote in message news:32D94955-47A5-4B96-8A1D-3F09235FD761@microsoft.com... >I have deleted 2 columns of info and have saved - is there anything I can >do > ! argh! scream & yell? afraid not! "Lang8er" <Lang8er@discussions.microsoft.com> wrote in message news:32D9...

CRM 1.2 Security Service will not start
This morning I am having an interesting error. Security Service did not start after reboot. When I tried to start it manually, an error appeared: Could not start the Microsoft CRM Security Service service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. I have no descriptive error in the Event Log. Hi Kerem, I see you posted this yesterday, have you been able to get the service started since then? If not, what account do you have the service set to start under? Has the account changed since installation? If so, make sure that ...