| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows based on no of rows specified from a given position
hi there.
how can i add the contents of the rows given the number of rows to add? i.e. a1 = 1 a2 = 2 a3 = 3 a4 = 4 a5 = 5 if b1 = no of rows to add = 3 then c1 = ? formula to sum up a1:a3 = 6 if b2 = no of rows to add = 2 then c2 = ? formula to sum up a4:a5 = 9 thanks very much. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding rows based on no of rows specified from a given position
You can do that like this in C1:
=SUM(INDIRECT("A1:A"&B1)) and this one in C2: =SUM(INDIRECT("A"&B1+1&":A"&B1+B2)) Hope this helps. Pete "nanette" wrote in message ... hi there. how can i add the contents of the rows given the number of rows to add? i.e. a1 = 1 a2 = 2 a3 = 3 a4 = 4 a5 = 5 if b1 = no of rows to add = 3 then c1 = ? formula to sum up a1:a3 = 6 if b2 = no of rows to add = 2 then c2 = ? formula to sum up a4:a5 = 9 thanks very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding rows of data based on first column | New Users to Excel | |||
| Insert new rows based on Data in other rows | Excel Worksheet Functions | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
| Adding a subset of rows of cells, SUM, based on Lookup | Excel Discussion (Misc queries) | |||
Linear Mode
