Pascal DeMilly wrote:
Hi,
How can I subtotal a column which has some empty cells. The sum aggregate only seems to work if the whole column has numbers?
I also tried unsuccessfully to replace all empty cells with zero, but
cannot find the correct regex. I tried stuff like [^:digit:]* or ^$ but
it doesn't work for me.
I am currently using 1.9.65 on Linux.
TIA
Pascal
Consider the following:
Although every Calc function can be used for database manipulation, the functions in Table 5 are more commonly used as such. Some functions names differ only by the letter appended at the end; AVERAGE and AVERAGEA, for example. Functions that do not end with the letter A operate only on numeric values and cells that contain text or are empty are ignored. The corresponding function whose name ends with the letter “A”, treats text values as a number with the value of zero; blank cells are still ignored.
......
so, you can probably use SUM, or even SUBTOTAL .
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
