| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I put a variable column number in the sum() function?
Shane,
No buttons shows. I thought you were just being funny. I'm using Mozilla (SeaMonkey). You'll have to press the button in my behalf. Thanks again! ... it worked! Bob Shane Devenshire wrote: Hi, The button is over on the right and has the comment Was this post helpful to you? But you wouldn't be the first person to miss it, and it may not even display that way in some browsers. Cheers, Shane "BobC" wrote: I also had trouble finding the button ... so I will type it ... *YES* Thanks! Bob Shane Devenshire wrote: Hi, The following formula should do the trick =SUM(OFFSET(F7,,,,A1)) If this helps, please click the Yes button Cheers, Shane Devenshire "BobC" wrote: I want to sum cells based on a number contained in cell A1 For example: I currently have the formula =SUM(F7:I7) which sums 4 of the cells in row 7 (form F to I). I would like to be able to have the number of cells in row 7 determined by a value in a specific cell such as cell A1 (in this example would have contained the number 4). I do not seem to be able to functions of any kind in the range sum expression? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum a variable number of items | Excel Worksheet Functions | |||
| Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Performing a function on a column of variable length | Excel Worksheet Functions | |||
| return the column reference number of a function result | Excel Discussion (Misc queries) | |||
![BobC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
