Hey guys, new to this forum but not forums in general. Your help is appreciated!
I want to sum each row in a single column, example:
Can I enter one formula in a new column to add each separate row together, or do I "HAVE" to enter the formula for each row like I have been doing?=J12+Q12
=J13+Q13
=J14+Q14
...ect
I have many sheets to do this to and would like to speed it along! Thanks for listening!
Try:
=SUM(J12:J18,Q12:Q18)
Adjust ranges to suit.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
The way I read your question, you are asking how to get the formula =J12 + Q12 to automatically update as go down the column. Is that right?
There are a number of ways. First fill in your first formula.
1. You can then drag the cell by grabbing the lower right hand corner of the cell (your cursor will change to a +) and dragging.
2. Select the range you want your formula to be in, including the cell you already filled (i.e. Z12). Hit CNTRL + D (copy down shortcut)
3. Copy the cell with the formula. Select the rest of the range (i.e. Z13:Z100) and PASTE (CNTRL + V).
Hope that helps.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
That did the trick!!! I'm almost done now! Thanks alot!!!!
Just curious, was it NBVC's interpretation or mine?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
If it is ChemistB's solution you say works, then you can also employ the List feature found in the Data menu.
It allows you to insert new rows, and automatically have formulas copy down to those new rows.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks