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
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
Shijesh Kumar
http://shijesh.wordpress.com/
Re: Making a formula work across each row!
Aaaaahh I feel so dumb! Thank you so much!!!!
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
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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 a dabbler in Cisco
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks