MS Office 2003 Excel Question.. Please Help
Started by
wadeb_21
, Mar 06 2007 02:46 PM
#1
Posted 06 March 2007 - 02:46 PM
#2
Posted 06 March 2007 - 04:11 PM
so you want the total for each row in one column right?
such as the sum of cells A1 and B1 through A300 and B300 to all show up in C1 through C300 right?
put your formula in C1 then click on that cell...hover your mouse over the bottom right corner of the cell...it should now turn into a + sign...click and drag all the way down to the last cell you want the formula to apply to...this will automatically fill each cell with the formula...and modify it to fit the context (i.e. A1+B1 will become A200+B200 in C200) make sense?
such as the sum of cells A1 and B1 through A300 and B300 to all show up in C1 through C300 right?
put your formula in C1 then click on that cell...hover your mouse over the bottom right corner of the cell...it should now turn into a + sign...click and drag all the way down to the last cell you want the formula to apply to...this will automatically fill each cell with the formula...and modify it to fit the context (i.e. A1+B1 will become A200+B200 in C200) make sense?
#3
Posted 06 March 2007 - 04:52 PM
Yes that makes sense. I will give it a try and see how it turns out. I appreciate the help thank you.
#4
Posted 07 March 2007 - 07:18 AM
I gave it a try and that worked thanks allot. Now I just feel like an idiot because it was something so simple lol, thanks again.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users