Grand-totals
- From: "gnumeric it actuarcalc com" <gnumeric it actuarcalc com>
- To: gnumeric-list gnome org
- Subject: Grand-totals
- Date: Mon, 29 Jan 2007 17:13:57 +0100
How do I make grand-totals (total of totals or something similar to that)?
There has been a technique permitting to transform a selection by
selecting only the visible cells of a selection. Using outlining, you
could rapidely set up a grand-total structure, opening and closing it at
will to calculate grand-totals using the sum function.
This button exists in Excel but cannot be used anymore to transform a
selection in a sum formula which is being built.Grand-totals are
probably the most useful function for guys who deal with money and the
"visible cell selection" is a very controlled and flexible technique
which could be a real advantage for a spreadsheet for "functional"
power-users. It existed as described in Excel 3.0 but has been de facto
abandoned for a guess method which tries to figure out totalization
level automatically.
Mathias
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]