Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

### #1 wadeb_21 Posted 06 March 2007 - 02:46 PM

Member

• Member
• 387 posts
My question is I have a Excel spreadsheet and I am trying to insert a function that will allow me to get the sum of of two cells and put the sum into the Third. Thats the easy part now the problem I am having is I want to highlight two whole colums (almost 600 cells apiece) and get the sum of each individual cell without having to do it one cell by one. I was wondering anyone knew how I could do that or if its even possible. If there is away to do that it would save me tons of time trying to do one by one. Thank you in advance.
• 0

### #2 dsenette Posted 06 March 2007 - 04:11 PM

dsenette

Je suis Napoléon!

• 26,024 posts
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?
• 0

### #3 wadeb_21 Posted 06 March 2007 - 04:52 PM

Member

• Topic Starter
• Member
• 387 posts
Yes that makes sense. I will give it a try and see how it turns out. I appreciate the help thank you.
• 0

### #4 wadeb_21 Posted 07 March 2007 - 07:18 AM

Member

• Topic Starter
• Member
• 387 posts
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.
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users