Recursive Functio help
I'm having trouble trying to create a function for a running total of data... 1 2 3 10,000 4 = sum(a3) 5 6 20,000 7 = sum(a6, a3) 8 9 30,000 10 = sum(a9, a6, a3) as you can see, i'm trying to create a recursive function that will keep a running total of all the values before it, but i'd like to use the same function for each... not just manually changing the function on each row, that way if I copy/paste, and add a new set of data at the end, the function will keep going. I've been trying to use a combination of INDIRECT(), and ADDRESS() functions, to isolate which cells to add, but the SUM() function doesn't let me use either of those functions inside of it. I've been searching for the answer myself for awhile, but can't find a solution. Anyone here have any ideas? -- BigBobbo ------------------------------------------------------------------------ BigBobbo's Profile: http://www.excelforum.com/member.php...o&userid=34310 View this thread: http://www.excelforum.com/showthread...hreadid=540761 |
Recursive Functio help
TRY
=SUBTOTAL(9,$A$3:$A3) in place of all your SUMs "BigBobbo" wrote: I'm having trouble trying to create a function for a running total of data... 1 2 3 10,000 4 = sum(a3) 5 6 20,000 7 = sum(a6, a3) 8 9 30,000 10 = sum(a9, a6, a3) as you can see, i'm trying to create a recursive function that will keep a running total of all the values before it, but i'd like to use the same function for each... not just manually changing the function on each row, that way if I copy/paste, and add a new set of data at the end, the function will keep going. I've been trying to use a combination of INDIRECT(), and ADDRESS() functions, to isolate which cells to add, but the SUM() function doesn't let me use either of those functions inside of it. I've been searching for the answer myself for awhile, but can't find a solution. Anyone here have any ideas? -- BigBobbo ------------------------------------------------------------------------ BigBobbo's Profile: http://www.excelforum.com/member.php...o&userid=34310 View this thread: http://www.excelforum.com/showthread...hreadid=540761 |
All times are GMT +1. The time now is 05:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com