On Sat, 25 Mar 2006 20:50:36 +0100 Cor Nouws <[EMAIL PROTECTED]> dijo:
> An answer that will partly help you: > - type '=' in a cell, and drag with the mouse over the cells that need > to be counted, than type Enter; > - the formula bar will disapear; > - however, putting the cursor in the cell with the formula and choosing > F2 will bring it back. There you can edit the formula. Cor, Thanks for the help. I managed to get all the chapters added up. But now I can't get a grand total. The totals for each chapter are in C1, C7, C11, C36, C54, and about 20 more non-contiguous cells. I put the cursor in the cell where I want the grand total and typed "=." That opened the formula window with the = sign in it. I typed the cells as: =<C1>+<C7>+<C11>+<C36>+<C54>+<C59> and so on. It added them up accurately for about the first six cells. Then it stopped adding any more. And as I kept adding more of the cells with the chapter total, it actually started subtracting random amounts. Anything above the first six cells gives bizarre answers. For example, the first six cells total 22:30, the seventh cell is 2:45, but when I add +<C64> (the seventh cell to be added) the grand total suddenly becomes 1:15. All cells in question are formatted as "time" and "12:37." Note that each of the cells being added is a sum of other cells. Those sums are all accurate, and created by the method you suggested. Unfortunately, I cannot use that method now because the cells to be added are non-contiguous. I looked at the formulas for the seventh and subsequent cells and I see no difference (other than the fact that they sum different ranges of cells). I could select the 25 individual cells with the chapter totals in them by holding down Ctrl, but then how do I sum them? Or does anyone have any other suggestions? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
