Excel 2010 beta autosum includes other sums in range!
in [General]
|
Prev: Can't insert row in data table in protected worksheet
Next: Excel Spreadsheet Link With Outlook Calendar
From: CarolChi on 1 Mar 2010 04:27 I notice that the autosum in Excel 2010 beta includes ALL cells above it, including a previous total. The older versions only took cells with numbers and truncated the range at the previous sum formula. Any ideas? -- Carol
From: Mike H on 1 Mar 2010 05:19
Hi, I have e2010 and it doesn't do that 1 2 3 4 5 Autosum here sums 4 & 5 or 1 2 3 Autosum of 6 4 5 Autosum here stops at 4 so =9 I can't find any setting to make it do otherwise. How are your data laid out? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CarolChi" wrote: > I notice that the autosum in Excel 2010 beta includes ALL cells above it, > including a previous total. > The older versions only took cells with numbers and truncated the range at > the previous sum formula. > > Any ideas? > -- > Carol |