Excel Cells not adding up

Discussion in 'Computer Support' started by Ben Lord, Oct 15, 2003.

  1. Ben Lord

    Ben Lord Guest

    Hi,

    Both my colleague and I have noticed that when you drag over a series of
    Cells in Excel 2000 to add them up, they are not adding up.

    I then manually go to enter in =sum(f2:f118) and it comes up with 0

    Any ideas how I can rectify this?
    --
    Kind Regards
    Ben Lord
    The New Inkjet Company
    Ben Lord, Oct 15, 2003
    #1
    1. Advertising

  2. Ben Lord

    Me Guest

    Do the cells contain numbers or labels?

    Ben Lord wrote:
    >
    > Hi,
    >
    > Both my colleague and I have noticed that when you drag over a series of
    > Cells in Excel 2000 to add them up, they are not adding up.
    >
    > I then manually go to enter in =sum(f2:f118) and it comes up with 0
    >
    > Any ideas how I can rectify this?
    > --
    > Kind Regards
    > Ben Lord
    > The New Inkjet Company
    Me, Oct 15, 2003
    #2
    1. Advertising

  3. Ben Lord

    Harrison Guest

    Make sure the cells are formatted for the correct data type.

    On Wed, 15 Oct 2003 20:58:43 +0100, "Ben Lord"
    <> wrote:

    >Hi,
    >
    >Both my colleague and I have noticed that when you drag over a series of
    >Cells in Excel 2000 to add them up, they are not adding up.
    >
    >I then manually go to enter in =sum(f2:f118) and it comes up with 0
    >
    >Any ideas how I can rectify this?
    Harrison, Oct 15, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Martin Schmid

    Re: Adding cells in Excel

    Martin Schmid, Jul 30, 2003, in forum: Microsoft Certification
    Replies:
    0
    Views:
    2,015
    Martin Schmid
    Jul 30, 2003
  2. Steve Freides

    How to format Excel cells as email addresses?

    Steve Freides, Sep 21, 2005, in forum: Computer Support
    Replies:
    8
    Views:
    34,060
    powerman1959
    Dec 28, 2010
  3. =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=

    convert yyyymmdd text cells into date cells

    =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=, Nov 22, 2006, in forum: Microsoft Certification
    Replies:
    2
    Views:
    3,544
    =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=
    Nov 22, 2006
  4. Richard Miller

    Combinding cells in Excel

    Richard Miller, Apr 11, 2006, in forum: Computer Support
    Replies:
    4
    Views:
    436
  5. Ed
    Replies:
    2
    Views:
    529
    WhzzKdd
    Feb 16, 2007
Loading...

Share This Page