excel

Discussion in 'Computer Support' started by mick, Jan 16, 2004.

  1. mick

    mick Guest

    help!!
    =SUM(H5:H6)+(12.5/100*SUM(H5:H6))
    can anyone tell me how I can change the above formula so that the 1st
    cell H5 stays the same for all lines.
    ie =SUM(H5:H7)+(12.5/100*SUM(H5:H7))etc to cell H25.
    This is part of a worksheet to keep a record of our power usage.
    mick
     
    mick, Jan 16, 2004
    #1
    1. Advertising

  2. mick

    Stevo Guest

    mick wrote:
    > help!!
    > =SUM(H5:H6)+(12.5/100*SUM(H5:H6))
    > can anyone tell me how I can change the above formula so that the 1st
    > cell H5 stays the same for all lines.
    > ie =SUM(H5:H7)+(12.5/100*SUM(H5:H7))etc to cell H25.
    > This is part of a worksheet to keep a record of our power usage.
    > mick


    Use $H$5 or if the column doesn't eve change H$5 will do it.

    :cool:

    --
    Stevo
    (pull the PIN to reply by e-mail)
     
    Stevo, Jan 16, 2004
    #2
    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. Tom
    Replies:
    1
    Views:
    548
    =?Utf-8?B?SWFu?=
    Dec 16, 2005
  2. Martin Schmid

    Re: Skill Level accessment for Word/Excel/Outlook users

    Martin Schmid, Jul 11, 2003, in forum: Microsoft Certification
    Replies:
    0
    Views:
    2,841
    Martin Schmid
    Jul 11, 2003
  3. Martin Schmid

    Re: Adding cells in Excel

    Martin Schmid, Jul 30, 2003, in forum: Microsoft Certification
    Replies:
    0
    Views:
    2,023
    Martin Schmid
    Jul 30, 2003
  4. rich

    EXCEL 2002 STEP BY STEP

    rich, Aug 6, 2003, in forum: Microsoft Certification
    Replies:
    1
    Views:
    943
    Craig Huggart
    Aug 8, 2003
  5. Denny G.

    Excel 2002 Mous Core Speecialist exam

    Denny G., Sep 5, 2003, in forum: Microsoft Certification
    Replies:
    0
    Views:
    973
    Denny G.
    Sep 5, 2003
Loading...

Share This Page