+ Reply to Thread
Results 1 to 5 of 5

Making a formula work across each row!

  1. #1
    Registered User
    Join Date
    09-19-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Angry Making a formula work across each row!

    Hi!
    Ugh, so I'm so frustrated. I'm working on a spreadsheet for a geology class, and I basically forget everything I've ever learned about using them in middle school.

    What I want to happen is this: I have this formula that I put into column AF row 9: "=((C9*D9)/100)+((F9*G9)/100)+((i9*j9)/100)+((l9*m9)/100)+((o9*p9)/100)+((r9*s9)/100)+((u9*v9)/100)+((x9*y9)/100)+((aa9*ab9)/100)+((ad9*ae9)/100)" and it works perfectly! Except I don't want to have to enter it in every row, changing the 9 to 10 and then 11 and on and on.

    Is there a way to say "Hey, Excel. I'd like to repeat this formula for every single row, putting the result in Column AF. And where I have 9 appearing here, please replace with the number of whatever row I am in."

    Ya know? I just want to run the same formula, across every row!

    Thanks in advance for the help!
    Ivy

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Making a formula work across each row!

    move the cursor on AF9

    At the right bottom corner u can see a small square , move the mouse over that square..

    drag the mouse down... and it will automatically enter the desired formula for u

  3. #3
    Registered User
    Join Date
    09-19-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Talking Re: Making a formula work across each row!

    Aaaaahh I feel so dumb! Thank you so much!!!!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Making a formula work across each row!

    May you can return some parens for extra credit:

    =(C9*D9 + F9*G9 + I9*J9 + L9*M9 + O9*P9 + R9*S9 + U9*V9 + X9*Y9 + AA9*AB9 + AD9*AE9) / 100
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Making a formula work across each row!

    if cells e9,h9,k9,n9,q9,t9,w9,z9,ac9 are empty or contain text then

    =SUMPRODUCT(C9:AD9,D9:AE9)/100
    Last edited by martindwilson; 09-19-2009 at 09:59 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1