#### Fill Down Problem

```I'm hoping you guys can help me out. I have a basic formula in cell C2 I
want to copy the formula down in the cells below.

The problem is that when I click the small black box in the corner of
the cell to fill down the same number appears and not the result of the

Here is the problem illustrated:

2     2     4                     2     2     SUM(A1,B1)
2     5     4                     2     5     SUM(A2,B2)
1     7     4                     1     7     SUM(A3,B3)
3     1     4                     3     1     SUM(A4,B4)

It is clear that 4 is not the sum of the rows below the first one, how
can I get Excel to return the correct value instead of dropping the
same number in everytime I try to fill down with the black square in
the corner of the cell?  Thanks!!

--
scwilly
------------------------------------------------------------------------
scwilly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18251

```
 0
6/7/2005 12:20:28 AM
excel 39879 articles. 2 followers.

3 Replies
441 Views

Similar Articles

[PageSpeed] 37

```You might check if:

<Tools> <Options> <Calculation> tab,

Has "Automatic" *CHECKED*

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"scwilly" <scwilly.1q8eqa_1118106301.1964@excelforum-nospam.com> wrote in
message news:scwilly.1q8eqa_1118106301.1964@excelforum-nospam.com...
>
> I'm hoping you guys can help me out. I have a basic formula in cell C2 I
> want to copy the formula down in the cells below.
>
> The problem is that when I click the small black box in the corner of
> the cell to fill down the same number appears and not the result of the
>
> Here is the problem illustrated:
>
> 2     2     4                     2     2     SUM(A1,B1)
> 2     5     4                     2     5     SUM(A2,B2)
> 1     7     4                     1     7     SUM(A3,B3)
> 3     1     4                     3     1     SUM(A4,B4)
>
> It is clear that 4 is not the sum of the rows below the first one, how
> can I get Excel to return the correct value instead of dropping the
> same number in everytime I try to fill down with the black square in
> the corner of the cell?  Thanks!!
>
>
> --
> scwilly
> ------------------------------------------------------------------------
> scwilly's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=18251
>

```
 0
ragdyer1 (4060)
6/7/2005 1:58:49 AM
```Should it be checked or unchecked?

--
scwilly
------------------------------------------------------------------------
scwilly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18251

```
 0
6/7/2005 2:35:09 AM
```scwilly Wrote:
> I'm hoping you guys can help me out. I have a basic formula in cell C2
> want to copy the formula down in the cells below.
>
> The problem is that when I click the small black box in the corner o
> the cell to fill down the same number appears and not the result of th
>
> Here is the problem illustrated:
>
> 2     2                              SUM(A1,B1)
> 2     5                              SUM(A2,B2)
> 1     7                              SUM(A3,B3)
> 3     1                              SUM(A4,B4)
>
> It is clear that 4 is not the sum of the rows below the first one, ho
> can I get Excel to return the correct value instead of dropping th
> same number in everytime I try to fill down with the black square i
> the corner of the cell?  Thanks!!
Hi,
IE:
=SUM(A1,B1)
Thx
Dav

--
Piranh
-----------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2043

```
 0
6/7/2005 8:14:41 AM

Similar Artilces:

WAB and Office 2k3 problem
Greetings All: I've Outlook 2003 connected to an Exchange 2003 server. The only addresses that appear in my address book are the Global Addresses from the server, my contacts do not appear. Now when I go to the appropriate "Outlook Address Book" tab in the contacts properties dialog, the "Show this folder as an e-mail Address Book" checkbox is grayed out. I have several other contact folders that exhibit the same grayed out checkbox. If I try to add them from the Options dialog in the Address Book specifically, they don't even show up in the as being avail...

money 2006 problems importing from bank
whenever I import information from my bank uccu, it says that the import is complete and that I have one statement to read with 150 transactions to review, but when it opens to the account register, none of the new transactions show up. It shows the correct amount and date from my bank in the left hand corner, and it says that I still have 150 transactions to review. I have tried changing the online settings, emptying the temporary internet files, repairing the money file, and setting the account register to show all transactions, but so far nothing has worked. I have been able to i...

Money2004 (No MSN, no Passport) -> Monwy2006 Any problems?
I use M2004 without MSN, Passport or passwords. My financial institutions (Citi cards, Fidelity, Bank One) download into M2004 without any problems. Will I be able to transition into M2006 without any problems? I'll be happy to maintain the current M2004 features and capabilities. I'm thinking of M2006 only because the on-line stuff for M2004 will expire next year. -- Aloke ---- to reply by e-mail remove 123 and change invalid to com I imported without a problem but cannot now use MSN. I did not before and did not have a Passport. Adding the Passport works but synching with MS...

Where Does Outlook Store Info? Computer Problems
Recently the power supply, motherboard, & CPU on my computer died. So I had a new motherboard, power supply, CPU and hard drive installed. The new hard drive is larger and faster than the old one. This required that Windows XP, Microsoft Office, etc, had to be installed. But before any of that was done, the technician took everything off the old hard drive and saved it into a file on the new one. All of the old data files, etc, are supposed to be there. My question, though, is how to find the address book and the saved emails that were on the old computer & put them into Outlook on the...

I downloaded the latest update for Outlook 2000. I did NOT have the installation cd handy. Okay, usually no problem, the instal quits. However this time, it did quit, yet now I am unable to open excel. It launches the instal program. The download was for Outlook. It has me boggled. Outlook, Word and Access open with no known problems. I have tried to open excel different times/ways. It continues to try to load the update. Any reasoning on the subject??? Thanks* ...

Edit the Auto Fill in the To: field
On the Send new message window, is there a way to edit the auto fill list for the To: Field. when i start to type in a name in the To Field the auto fill will provide a list of names to choose from. the one i most use is on the bottom of the list. How do i edit the list to get the one i use most to the top? Do you use the others as well? Editing the list will remove them from the list. If you again use the names, they will be added back to the same position. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the Swen virus, all e-...

Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call them A, B and C). These 3 pages have formulas that link to each other. Sheet A has a few checkboxes that link to sheet C. The problem is that when I try to check any of the check boxes on sheet A an error box pops up that says "The cell or chart you are trying to change is protected and therefore read only". Is there a way to protect a sheet while being able to check a box off that is linked to another sheet? What protection options would allow me to do this? Thanks in advance. Dave -- Dave123 ----------...

Connectivity Problems
Sorry about the length of this post, but I have no idea what I'm talking about, let alone explain it! We have two sites (Head Office and Remote) with a Netgear FVS338 VPN firewall at each end. The remote site connects via a Terminal Server and runs a couple of EPOS systems. Our setup in the Head Office is thus: Workstation -> SBS 2003 R2 Standard -> FVS338 VPN Firewall -> Internet Router Recently, the VPN keeps dropping and if I set up a permanent ping I can see that several times a day we get 7 or 8 pings timing out. This is enough to kill the EPOS connect...

Timesheet Problem #2
I am trying to populate a timesheet with dates depending on the start date in B2. If B2 is the 16th of the month of Sept, I don't want anything to show up on the calendar for the 31th (blank in other words). Here is the formula I am using, but not working. Help. TIA =IF((\$B\$2)="","31",IF(EOMONTH(B2,0)=TEXT((\$B\$2)+ROW()-14,"DDD dd"),"",TEXT((\$B\$2)+ROW()-14,"DDD dd"))) Greg Hi Greg, With seed date in cell \$B\$2 and using rows down to leave the 31st blank. But show all other dates no exceptions for weekends and holidays. EOMONTH is in ...

problem with csv
When I export from a database I get the top line all in csv which appears to be in row A (which is the names of all the columns and the rest of the sheet is correct with all the data in relevant columns. How do I split that top row (which is Comma Separated) into coulumns automatically. I'm sure it is a simply process. thanks plato There is an easy way in Excel to split apart a cell without having to re-type its contents. Click on the cell. Pull-down Data > Text to Columns... > then check delimited and next check comma. The single cell should then split. Good Luck -- G...

Multiple problems with WLM
Multiple problems with WLM I realize that this problems list is long enough that it's unlikely that just one person will be able to solve them all. Therefore, it's OK to reply only for the one you can handle. Since some of these problems may be related, I decided to list them all in one post. 1. The All news view in the Quick views is either mislabelled, or unable to handle very large collections of unread newsgroups posts (I first saw this problem when the count was over 1,000,000, WLM was restarted, and the count dropped much lower (under 50,000). Since then I&#...

To auto-fill using names no longer in address
Is there a way to remove the names for the auto fill feature that are no longer in the address book or contact list? If they are selected the properties for the entry states name is no longer valid Address Book entry. Thanks. State your Outlook version and what you mean by "autofill." Outlook has two different functions this could be: autoresolution or autocompletion. -- Russ Valentine [MVP-Outlook] "Ernie C" <anonymous@discussions.microsoft.com> wrote in message news:04e601c4913a\$f07a15c0\$7d02280a@phx.gbl... > Is there a way to remove the names for the au...

Moving Range Problem
Hi all, I'm trying to build a 6 Sigma control chart into an excel workbook. In order to do this i need to be able to work out a formula for the moving range. I need the following : Eg Data sample : 210 , 425 , 600 , 550 , 450 , 470 The moving range is the distance from second to the first, third to the second etc eg A B C D E F Data Sample 210 , 425 , 600 , 550 , 450 , 470 Moving Range 215, 175 , 50 , 100 , 20 The problem I'm having is trying to get excel to work it out. If say 210 was in A1 i ...

Bank Recon GP 10 problem
Hi We are a VAR that's upgraded one client to GP 10 and installed GP 10 for another new client, both on SQL 2000. In both cases there's an incorrect balance showing for Cashbook Balance field (cashbook maintenance screen) using the Bank Recon module. Also the cashbook balance is not re-calculated (recon screen) when "Incl Trans To Date" field is changed, for both clients. We can update the balance in Cashbook Master table (CM00100) in SQL but this doesn't solve the problem. Any suggestions? ...

Pivot Table Refresh error "Problems Obtaining Data"
I can't seem to get data or change the data source. When I refresh, I get the error message "Problems Obtaining Data" When I start the Pivot Table Wizard, the back button is grayed out so that I can't go back and change data sources. Any help is appreciated. ...

Admin Problem from 5.5 to 2k3 Exchange
We just migrated all of our email boxes to Exchange 2k3 from Exchange 5.5. Now our administrators can't look at any of the users outlook information unless they are given the rights from that users. Before the administrators could look at the persons information and remove or help the people with problems and questions if need be. How can our Administrators gain access to these exchange boxes again? There are several articles out there on this. In E2K3, domain admins and enterprise admins are explicitly denied this access. There are work arounds. try this: http://www.winnetma...

XML DATASET problem
I am having big problem manipulating XML in a dataset. I am reading in a schema based on the following XML document. The minute I try to e.g. create a new row I get 'Object reference not set to an instance of an object' error <?xml version="1.0" encoding="utf-8"?> <DocumentElement xmlns="http://tempuri.org/dseditted2.xsd"> <TableInfo> <FieldName>column value</FieldName> <ControlType>column value</ControlType> <IsNull>column value</IsNull> <MaxLength>column value</MaxLength> </TableInfo&g...

Problem with external data and #reference error
Hi, my Excel workbook has 2 sheets: 1. Source: with an external data reference to a MS Access database Query property "If number of rows changes after refresh" is set to option #1: "Insert cells for new data, delete unused cells" User chooses external query selection criteria and therefore can have different result sets. 2. Target: Formular B4: =Source!P5 Formular B5: =Source!P6 Formular B6: =Source!P7 Problem: When Source has data in rows 5, 6 and 7 formular gets calculated correctly. If Source row #5 has data and #6 and ...

Problem with copying and pasting tasks and keeping predecessors in
I am doing a consulting project for an organization that has a bit of an unusual request. We are doing a conversion from an old mail system to Microsoft Exchange 2007. We have developed a checklist for the technicians to follow with about 50 detailed tasks (things like, "Open up Exchange Management Console", "Assure the 'Forward' Button is unchecked", etc.). The CIO expects me to enter each of the tasks from the checklist into the project plan. Instead of having a line on the project plan with a task, "Covert Leroy Smith's Mailbox" wi...

Charting Problem #2
I have a problem with charting a Dynamic chart. I goes ok to set up the dynamic function as a range. It also shows the correct series. The range is as follows: =OFFSET(Sheet3!\$A\$1;1;Sheet3!\$P\$2-1;COUNTA(INDIRECT("C"&Sheet3!\$P\$2;FALSE));1) Where P2 is an input from a listbox, and the name of the range is: Sheet3!Dato. When I try to change the reference for the series i get the following message: "Your formula contains an invalid external reference to a worksheet. Verify the path, workbook, and range name or cell reference are correct, and try again." The serie...

can the fill colour of a bar be tied to the data font colour data
...