Hmm that is a good question, I did what you indicated by cutting a row And noticed the formulas change and such.
Not sure if there is a work-around or not. Have to keep plugging away At it and see if there is anything I can come up with. -----Original Message----- From: Vivec [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 10:49 AM To: CF-Community Subject: Re: Basic Invoice On another note.. Here's an excel question. That invoice...there's a total field which is essentiall a Sum field down at F26. Now this is supposed to Sum all the rows between F16 and F25. All the rows in one column. Simple stuff right? Adding up a column of numbers and giving a total at the end. So 500 600 345 900 -------- 2345 -------- Right? But! Let's say for some reason, you need to switch numbers around. And you CUT 900 out of the list, and paste it somewhere else. What happens to the excel formula Sum(F16:F25) in that case, is that it becomes Sum(F16:F40) (If you PASTE 900 to F40) This will of course pose a big problem, and what I end up doing is resetting the Formula back to Sum(F16:F24) This only happens if you CUT the Start of the range, or the End of the range. If you were to cut F18 or F19 for example then everything remains the same and the formula holds. Is there a way around this? I have a spreadsheet where I need to do numerous Cuts and Pastes of rows of data to different sections, and each time I do that, I have to go back to the Totals formula and reset each Sum back to the proper ranges. It's tedious, and certainly not as quick as cutting and pasting rows of data and immediately seeing how the totals add up. Plus, if you ever forget to reset the Sum ranges then the calculations for the entire sheet end up being off. On 6/7/06, Vivec <[EMAIL PROTECTED]> wrote: > *quickly swipes the invoice* > > Free invoices! Free INvoices! > Wheeee! > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:208300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
