Welcome to iPadForums.net Guest - Click Here to Register

Numbers

This is a discussion on Numbers within the iWork Forum forums, part of the iPad App Store category; Hi I'm new on here so I'm not sure how this works, but here is my problem: I have set up a weekly diary on ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 8 of 8

Thread: Numbers

  1. #1
    iPF Noob
    Member #
    185744
    Join Date
    Apr 2012
    Posts
    1

    Numbers

    Hi
    I'm new on here so I'm not sure how this works, but here is my problem:
    I have set up a weekly diary on numbers (like I used to on excel) and it works well as I can see my daily income totals.
    The problem is, I cant work out how to total rows, not column, as it defaults to columns and when I tried a formula to include the row cells to add it comes up with an error message.
    I'd like this facility so I can see my weekly totals.
    Help please?

  2. Ads


  3. #2
    Administrator
    Member #
    48665
    Liked
    946 times
    Join Date
    Apr 2011
    Location
    Brisbane, Australia
    Posts
    23,479
    Hi and welcome to the Forum!

    Sit tight and someone will be along who can answer your question, in the meantime:

    The IPad Forum is a community of members from all walks of life and from all over the world coming together to share our experiences and to help each other learn about this wonderful piece of technology the Ipad. There is a wealth of information already here in the many threads we have so doing some searches will answer most of the questions you have. If then you cannot find the answer you are seeking then by all means post your question. There are many friendly and informed members here only too willing to help you.

    We also have our own App - It is a very simple app to navigate.
    http://itunes.apple.com/us/app/discu...412896524?mt=8
    Reading the IPad manual is a great place to start so please download a copy of these.
    http://www.support.apple.com/manuals/ipad/
    2 very informative threads from which you will learn many tips and shortcuts for the IPad.
    http://www.ipadforums.net/ipad-gener...dont-know.html
    iOS5 Tips and Tricks
    We have rules like any Community so please read these also
    Forum rules - everybody please read!!

    Once again we welcome you here and are so pleased you have joined us!

    Please read the Forum Rules
    iPad Air 128gb Wifi/Cellular - iPad 2 64gb Wifi/Cellular - iPad Mini 32gb Wifi/Cellular - iPhone 5 - Apple TV - MacBook Pro 15" - Time Capsule - Airport Express

  4. #3
    iPF Noob
    Member #
    185990
    Join Date
    Apr 2012
    Posts
    1
    Thanks. Good to be part of this forum. Looking forward to learning. Looking for an app that scans business cards.

  5. #4
    Administrator
    Member #
    48665
    Liked
    946 times
    Join Date
    Apr 2011
    Location
    Brisbane, Australia
    Posts
    23,479
    Quote Originally Posted by CDW50
    Thanks. Good to be part of this forum. Looking forward to learning. Looking for an app that scans business cards.
    I just had a look in the app store, there are a few

    Numbers-image-2222891519.jpg

    Have a look at Evernote Hello also, while it doesn't scan, all info can be input to link with Evernote
    Could be a good suggestion to the developers for scanning ability.

    Please read the Forum Rules
    iPad Air 128gb Wifi/Cellular - iPad 2 64gb Wifi/Cellular - iPad Mini 32gb Wifi/Cellular - iPhone 5 - Apple TV - MacBook Pro 15" - Time Capsule - Airport Express

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    The SUM key is a shortcut for the most common use of SUM, to sum a column. To sum a row you must go through the formula editor.

    Select the cell you want the formula in by double tapping, Then tap the = sign to the left of the editor's field to enter formula mode. Now tap the Formula key and select SUM from the list (you may have to search for it).

    Numbers-rowsum1.jpg

    Now you should see the formula in the editor. The Value variable will be highlighted a dark blue. This means you are ready to select it's values from the table.

    If you have chosen a header row for your formula you can select the entire row. This is handy when you don't know how many cells in the row will eventually be added. You'll be able to keep adding on to the row without having to edit the formula.

    If your cell is not a header row then you select and drag to choose the cells you want to SUM. This is handy if you want to place the SUM cell anywhere but in the header of the same row.

    Now tap the checkmark to the right of the formula entry field to finish the formula. If there were no mistakes made it will be done.

    Numbers-rowsum2.jpg
    Last edited by twerppoet; 04-04-2012 at 08:37 PM.

  7. #6
    Banned
    Member #
    186850
    Join Date
    Apr 2012
    Posts
    3
    good to know

  8. #7
    Banned
    Member #
    186850
    Join Date
    Apr 2012
    Posts
    3
    thanks

  9. #8
    Banned
    Member #
    186850
    Join Date
    Apr 2012
    Posts
    3
    I will definetly lok into thi and reply soon


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Replies: 1
    Last Post: 02-15-2012, 09:40 PM
  2. Numbers help
    By Jockscrap in forum iPad Help
    Replies: 0
    Last Post: 11-24-2011, 04:55 PM
  3. Numbers
    By rudie124 in forum Dutch Dedicated iPad Forum
    Replies: 2
    Last Post: 10-24-2011, 04:47 AM
  4. Column/Row letters/numbers in Numbers
    By MikeV99 in forum iPad Apps
    Replies: 3
    Last Post: 07-22-2011, 02:10 PM
  5. Numbers
    By jimdd in forum iPad Apps
    Replies: 1
    Last Post: 02-07-2011, 01:18 AM

Search tags for this page

how to add (sum) a column in numbers on the ipad
,

how to do numbers sum on ipad

,

how to find sums of numbers on an ipad

,

how to sum in numbers on iphone

,

how to sum rows in numbers ipad

,
sum a column in numbers ipad
,

sum row numbers ipad

,

sumif numbers ipad

Click on a term to search for related topics.