Skip navigation
This discussion is archived

Spreadsheet basics ( can't add up)

287 Views 4 Replies Latest reply: Feb 27, 2006 3:11 AM by Ken. RSS
Clive P. Calculating status...
Currently Being Moderated
Feb 25, 2006 4:36 AM
I'm really new to spreadsheets and I just want to make a basic layout that will let me enter amounts across and down and then automactically add them all up.
I've made a spreadsheet that works (9 coloums wide by 30 rows high) but if I use more than 30 rows the calculation doe's not work.

A message saying the fomular is incorrect or the fomular it self appears.

I'm only entering small numbers (less than 10) into each cell so the total is never very big, but I really need to be able to add up about 50 rows.

thanks in advance for any help.

G5,G4,G3,Performa and even a Mac aqurium!   Mac OS X (10.3.9)  
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Feb 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:

    =SUM(A1..A42)

    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)
  • Ken. Level 6 Level 6 (10,225 points)
    Currently Being Moderated
    Feb 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)
  • Ken. Level 6 Level 6 (10,225 points)
    Currently Being Moderated
    Feb 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)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.