# Making a formula work across each row!

1. ## 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  Register To Reply

2. ## 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  Register To Reply

3. ## Re: Making a formula work across each row!

Aaaaahh I feel so dumb! Thank you so much!!!!  Register To Reply

4. ## 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  Register To Reply

5. ## 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  Register To Reply

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