You are here:

- Home
- Computing/Technology
- Business Software
- Excel
- a formula to numbers

Advertisement

I would like to create a formula to add numbers which are a specific number of cells apart in a column. For example, these numbers may be in cell A5, A10, A15, A20, A21, etc. I would like the total of those in summary at the bottom of the column.

Then I would like to have a "relative reference" so that I can copy/paste the formula to add B6, B11, B16, B21, B26, etc. I hope you can understand my question. Thank you.

Darlene

Not sure what is meant---when you say "add" numbers do you mean put a number in a cell or do you mean sum the numbers.

If you mean sum the numbers in certain cells then are there any other criteria other than the cells are X cells apart, if so then a sumif formula may be appropriate and the easiest to work with. If not then a simple formula created in the first column is pretty easy to create, something like

=A1+A5+A10+A15+A20+A25+A30+A35+A40+A45+A50

I don't know how many increments you need, but its pretty easy to create this formula by putting a + and then clicking on the next cell that you want to add. To make this formula reference the next sequence of cells the easiest way is to copy it one column to the right and one row down this will make the formula look like this

=B2+B6+B11+B16+B21+B26+B31+B36+B41+B46+B51

If you need the formula to be on the same row as the column A formula then first eliminate the = sign in front of the formula and move it up one row then put the equals back in front of the formula.

Hope this gives you some ideas.

Richard

Florida

USA

This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

Answers by Expert:

Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.

Have been working with Excel for about 20
years primarily in accounting and financial areas.**Education/Credentials**

BA, Certified Public Accountant