I have my template the way I want it. In the different columns I want to add a $ amount each month of the year and at the end of the year I would like the Total to be cumulative for the year. How do I learn to add the formula for that?
iMac 500 G3, Mac OS X (10.4.11), iBook 500 G3 OS 10.4.10
Hi John,
The pasted version of each formula shows an extra space following the formula, but that should be ignored by AppleWorks and have no effect on whether the formula works. When pasted and filled into a new sheet here, both formulas produced the expected results.
When you did the fill routines, what was displayed in cell F14? The two most likely answers, if the cell is showing a formula, are
=SUM(B2..B14) or =SUM(F2..F14)
The first would support Yvan's guess--there's a space or other invisible character before the = sign causing AW to see the formula as text, not a formula. Click on the cell (B14), then without moving the mouse, retype the formula and press return. What you type will replace everything in the cell. Repeat for G2, then do the fills as before.
The second indicates the formula was correctly entered and recognized as a formula. When filled right, AppleWorks automatically adjusted the cell references to the appropriate column.
My guess in that case would be that the spreadsheet is set to show Formulas. Go to the Options menu, choose Display... and uncheck the Formulas checkbox.
Regards,
Barry
The pasted version of each formula shows an extra space following the formula, but that should be ignored by AppleWorks and have no effect on whether the formula works. When pasted and filled into a new sheet here, both formulas produced the expected results.
When you did the fill routines, what was displayed in cell F14? The two most likely answers, if the cell is showing a formula, are
=SUM(B2..B14) or =SUM(F2..F14)
The first would support Yvan's guess--there's a space or other invisible character before the = sign causing AW to see the formula as text, not a formula. Click on the cell (B14), then without moving the mouse, retype the formula and press return. What you type will replace everything in the cell. Repeat for G2, then do the fills as before.
The second indicates the formula was correctly entered and recognized as a formula. When filled right, AppleWorks automatically adjusted the cell references to the appropriate column.
My guess in that case would be that the spreadsheet is set to show Formulas. Go to the Options menu, choose Display... and uncheck the Formulas checkbox.
Regards,
Barry