New to Excel - I want to add a few columns across (P and Q)...How? in Excel New users    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Blake 1/13/2005 5:46 PM PST   Question   I am trying to learn how to add, substract, multiply, and divide columns in an Excel spreadsheet. I know how to add the contents of a column down that column but I cannot understand the instructions of how to add columns across the spreadsheet. I want to be able to add columns to get a result (P+Q=R...ie OBP+SLG=OPS) as well as multiply, divide and substract. Anyone offering assistance will be greatly appreciated.     Was this post helpful to you?         Reply |   Top           Michael 1/13/2005 6:01 PM PST   Answer   Hi Blake To add columns, you still need a cell reference, not just a column. eg, In C1 put =A1+B1 to multiply =A1*B1 To Subtract =A1-B1 To Divide =A1/B1 Once these columns are done you can SUM/Divide, etc, the totals down the page HTH Michael "Blake" wrote: > I am trying to learn how to add, substract, multiply, and divide columns in > an Excel spreadsheet. I know how to add the contents of a column down that > column but I cannot understand the instructions of how to add columns across > the spreadsheet. I want to be able to add columns to get a result > (P+Q=R...ie OBP+SLG=OPS) as well as multiply, divide and substract. Anyone > offering assistance will be greatly appreciated.     Was this post helpful to you?         Reply |   Top           Blake 1/13/2005 6:32 PM PST   Okay, that I can do. Now, how may I write this formula so that the addition will automatically happen all the way down the column? (ie. in column R, I want the addition of P1+Q1 and P2+Q2 to be added all the way down column R). Thanks! "Michael" wrote: > Hi Blake > To add columns, you still need a cell reference, not just a column. > eg, In C1 put =A1+B1 > to multiply =A1*B1 > To Subtract =A1-B1 > To Divide =A1/B1 > > Once these columns are done you can SUM/Divide, etc, the totals down the page > > HTH > Michael > > "Blake" wrote: > > > I am trying to learn how to add, substract, multiply, and divide columns in > > an Excel spreadsheet. I know how to add the contents of a column down that > > column but I cannot understand the instructions of how to add columns across > > the spreadsheet. I want to be able to add columns to get a result > > (P+Q=R...ie OBP+SLG=OPS) as well as multiply, divide and substract. Anyone > > offering assistance will be greatly appreciated.     Was this post helpful to you?         Reply |   Top           Michael 1/13/2005 6:47 PM PST   Answer   Once you have written the first formula in say R1. Click on the little black box in the bottom right corner of R1 and drag it down as far as you need to, and excel will transfer the formula down for you. Michael "Blake" wrote: > Okay, that I can do. Now, how may I write this formula so that the addition > will automatically happen all the way down the column? (ie. in column R, I > want the addition of P1+Q1 and P2+Q2 to be added all the way down column R). > Thanks! > > "Michael" wrote: > > > Hi Blake > > To add columns, you still need a cell reference, not just a column. > > eg, In C1 put =A1+B1 > > to multiply =A1*B1 > > To Subtract =A1-B1 > > To Divide =A1/B1 > > > > Once these columns are done you can SUM/Divide, etc, the totals down the page > > > > HTH > > Michael > > > > "Blake" wrote: > > > > > I am trying to learn how to add, substract, multiply, and divide columns in > > > an Excel spreadsheet. I know how to add the contents of a column down that > > > column but I cannot understand the instructions of how to add columns across > > > the spreadsheet. I want to be able to add columns to get a result > > > (P+Q=R...ie OBP+SLG=OPS) as well as multiply, divide and substract. Anyone > > > offering assistance will be greatly appreciated.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies