| View previous topic :: View next topic |
| Author |
Message |
exister86
Newbie
Joined: 25 Jan 2007
Posts: 1
|
 Posted: Thu Jan 25, 2007 3:40 am Post subject: help in calc... |
 |
|
| i would like to create a format where when i highlight(wif a specific colour) a specific cell(containing date), the format will sum up the results from the date. and does anyone knows how to use the auto filter to filter separate cells. |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Jan 25, 2007 4:51 pm Post subject: |
|
|
Formatting is unrelated to information (content of a cell). The program won't be able to calculate anything based on formatting. the other way round works pretty well: Apply formatting based on content. There are several tools for creating subtotals of lists. You may try Data>DataPilot or cell-function SUBTOTAL, which can build sums and other aggregations, while disregarding cells hidden by a filter.
A data pilot combined with grouped dates can show subtotals for years, months and quarters and it can be filtered as well.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
