Numbers

Discussion in 'iWork Forum' started by suefreem, Apr 3, 2012.

  1. suefreem
    Offline

    suefreem iPF Noob

    Joined:
    Apr 3, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    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. leelai
    Offline

    leelai Administrator Staff Member

    Joined:
    Apr 24, 2011
    Messages:
    24,857
    Thanks Received:
    1,287
    Trophy Points:
    113
    Location:
    Brisbane, Australia
    Ratings:
    +1,361 / 0
    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/discussion-forum-for-ipad/id412896524?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-general-discussions/21590-tips-tricks-those-us-who-dont-know.html
    http://www.ipadforums.net/ipad-os/49581-ios5-tips-tricks.html
    We have rules like any Community so please read these also
    http://www.ipadforums.net/forum-rul...um-rules-everybody-please-read.html#post14697

    Once again we welcome you here and are so pleased you have joined us!
  3. CDW50
    Offline

    CDW50 iPF Noob

    Joined:
    Apr 3, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Thanks. Good to be part of this forum. Looking forward to learning. Looking for an app that scans business cards.
  4. leelai
    Offline

    leelai Administrator Staff Member

    Joined:
    Apr 24, 2011
    Messages:
    24,857
    Thanks Received:
    1,287
    Trophy Points:
    113
    Location:
    Brisbane, Australia
    Ratings:
    +1,361 / 0
    I just had a look in the app store, there are a few

    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.
  5. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,516
    Thanks Received:
    2,068
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,401 / 1
    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).

    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.

    RowSum2.jpg
    Last edited: Apr 4, 2012
  6. yourlips2
    Offline

    yourlips2 iPF Noob

    Joined:
    Apr 5, 2012
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    good to know
  7. yourlips2
    Offline

    yourlips2 iPF Noob

    Joined:
    Apr 5, 2012
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    thanks
  8. yourlips2
    Offline

    yourlips2 iPF Noob

    Joined:
    Apr 5, 2012
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I will definetly lok into thi and reply soon
Similar Threads
  1. alkan
    Replies:
    4
    Views:
    3,457
  2. markskidmore
    Replies:
    4
    Views:
    1,125
  3. rmpresti
    Replies:
    3
    Views:
    517
  4. Richard Webb
    Replies:
    2
    Views:
    893
  5. Pauley
    Replies:
    9
    Views:
    786
Loading...

Share This Page

Search tags for this page
how do i get a sum total how to add in ipad numbers
,
how do i get the sum in the numbers app
,
how do you total columns in numbers app
,

how to add a column of numbers in numbers on ipad

,

how to do numbers sum on ipad

,

how to find sums of numbers on an ipad

,
how to get sums in numbers app
,

how to sum a column in numbers app for ipad

,
how to sum in apple numbers
,
how to sum on numbers app
,

how to sum rows in numbers ipad

,

how to total a column in numbers app for ipad

,
how to use sumif in ipad numbers
,
ipad air sumif formula
,

ipad numbers app sum column

,
numbers on my ipad how to buy sum column
,
sum numbers in ipad
,
sum of symbol on ipad
,

sum row numbers ipad

,

sumif numbers ipad