This discussion is archived
287 Views 4 Replies Latest reply: Feb 27, 2006 3:11 AM by Ken.
Currently Being ModeratedFeb 25, 2006 10:27 AM (in response to Clive P.)Hello
I am quite sure that you are using a formula like:
=A1A2+A3+A4A5… which when you reach about 30 cell references will fill the formula buffer.
The correct way to do what you want is to use the function named SUM().
Theformula will look something like:
It would perhaps be helpful to search in the Help for the keyword: "functions"
You will get the list of the numerous functions available and the calling syntax.
Yvan KOENIG (from FRANCE samedi 25 février 2006 19:25:33)Don't forget you can use Search and/or the FAQ (and its Users Contributed Tips) before asking., Mac OS X (10.3.9)
Currently Being ModeratedFeb 25, 2006 1:52 PM (in response to Clive P.)You may have missed the autosum button. Look at the button bar for an odd looking "E" (or sigma). Highlight a row or column of cells. The last cell must be blank since that's where the results will be. When you highlight that last cell you'll see how the sum formula looks and works.iMac G5 2.0 + iBook G3 600, Mac OS X (10.4.5)
Currently Being ModeratedFeb 27, 2006 3:11 AM (in response to Clive P.)AW6 is less than intuitive in spots. There are "fly over" tooltips for the various buttons but few folks hover over a button long enough for the information to pop up. The Help files have not been updated in ages. These forums are brilliant since just about anything that can be done with this program, has been done. Despite it's age and quirks AW is an amazing program. Few programs, if any, provide so much function in so small a package.iMac G5 2.0 + iBook G3 600, Mac OS X (10.4.5)