| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks Alex. I'll give it a try.
jch "Alex Delamain" wrote: Here's a suggestion - try using =offset() in your formulae. For example: If your data has column headings in row 1 add a new row above it. Then in cell A1 enter =counta($a:$a)-2 (the -2 is to account for the cell itself and the heading) This will give the number of rows of data and will update when rows are added or deleted. For your formulae you then use this number of rows in an offset function =offset(reference,rows,cols,height,width) so if column B has monthly sales starting in B3 the last 12 months total is: =SUM(OFFSET(B2,$A$1,,-12)) No matter how many rows are added or removed this will always sum the last 12 rows hope it helps -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 View this thread: http://www.excelforum.com/showthread...hreadid=394062 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Can I set up the formula to update automatically? | Excel Worksheet Functions | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
| how do I disable the formula bar? | Excel Discussion (Misc queries) | |||
Threaded Mode
