Total cells when range is unknown FirstVette52 12/31/2008 4:56:05 PM Thank you to any who dare... this may not be possible but I appreciate your comments. I have an extracted range and need to add a total to the next row after its last extracted record each time it runs. Some times I get 2 records, sometimes 70, but in each case I need the next row after the last record to contain a sum of all values in a given column, but only in the extracted data (above the extracted data are the data source records). The Extract range always begins in cells A213:G213. A212:G212 contains the Headings for the cells. Thx! -- FirstVette52

Re: Total cells when range is unknown Reitanos <reitanospa1[ at ]yahoo.com> 12/31/2008 5:07:28 PM What if you put the total ABOVE the data and then used a formula like SUM(A213:A65000)? On Dec 31, 11:56 am, FirstVette52 <(My User name is Firstvette 52, too) firstvet52[ at ](my ISP E-mail provider is) netzero.com> wrote: [Quoted Text] > Thank you to any who dare...  this may not be possible but I appreciate your > comments. > > I have an extracted range and need to add a total to the next row after its > last extracted record each time it runs. > Some times I get 2 records, sometimes 70, but in each case I need the next > row after the last record to contain a sum of all values in a given column, > but only in the extracted data (above the extracted data are the data source > records). > > The Extract range always begins in cells A213:G213. A212:G212 contains the > Headings for the cells. > > Thx! > -- > FirstVette52

Re: Total cells when range is unknown google[ at ]magneticnorth.ca 12/31/2008 5:25:31 PM What if you put a SUM(A213:A9999) into A10000 and Format->Row->Hide everything from... say... rows 215 to 9999? Columns B through G would receive similar treatment.

RE: Total cells when range is unknown Shane Devenshire 12/31/2008 5:33:02 PM Hi, 1. To put it below you could write a macro. 2. Or you could put the calculation far below the last possible extract row and then use autofilter to hide all the blank rows between the calculation and the last extracted value. In the second case you can set up the autofilter and calculation formulas before you do the extract so it only needs to be done once. -- If this helps, please click the Yes button Cheers, Shane Devenshire "FirstVette52" wrote: [Quoted Text] > Thank you to any who dare... this may not be possible but I appreciate your > comments. > > I have an extracted range and need to add a total to the next row after its > last extracted record each time it runs. > Some times I get 2 records, sometimes 70, but in each case I need the next > row after the last record to contain a sum of all values in a given column, > but only in the extracted data (above the extracted data are the data source > records). > > The Extract range always begins in cells A213:G213. A212:G212 contains the > Headings for the cells. > > Thx! > -- > FirstVette52

RE: Total cells when range is unknown FirstVette52 12/31/2008 6:41:04 PM Thank you all so much! Putting the total far below will work, so will putting it above. Thanks Again! -- FirstVette52 "Shane Devenshire" wrote: [Quoted Text] > Hi, > > 1. To put it below you could write a macro. > > 2. Or you could put the calculation far below the last possible extract row > and then use autofilter to hide all the blank rows between the calculation > and the last extracted value. > > In the second case you can set up the autofilter and calculation formulas > before you do the extract so it only needs to be done once. > > -- > If this helps, please click the Yes button > > Cheers, > Shane Devenshire > > > "FirstVette52" wrote: > > > Thank you to any who dare... this may not be possible but I appreciate your > > comments. > > > > I have an extracted range and need to add a total to the next row after its > > last extracted record each time it runs. > > Some times I get 2 records, sometimes 70, but in each case I need the next > > row after the last record to contain a sum of all values in a given column, > > but only in the extracted data (above the extracted data are the data source > > records). > > > > The Extract range always begins in cells A213:G213. A212:G212 contains the > > Headings for the cells. > > > > Thx! > > -- > > FirstVette52