Maybe I've not understood your question but you can certainly sum several rows in a single column, even if some of the cell contents are empty. I'm assuming that you using calc.
Not wanting to advise how to suck eggs, the formula is sum(FIRSTCELL:LASTCELL). You can do more than one column with the same formula but I don't think that is what your asking. If you wanted to turn the blank cells into zero, in the next column (to the left or right) try the following formula: =IF(ORIGINALCELL<>"";ORIGINALCELL;0) Where the ORIGINALCELL is the cell in the column that has the original value. This will copy over the contents of the cell if it is not blank and put a zero in the cell if it is. All you then need to do is copy the contents of the column back onto the original using 'paste as'. If this does not assist reply to the list...HTH, Paul On Wed, 26 Jan 2005 09:18:45 -0800, Pascal DeMilly <[EMAIL PROTECTED]> 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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
