Welcome to iPadForums.net Guest - Click Here to Register

rectify formula malfunctions

This is a discussion on rectify formula malfunctions within the New Member Introductions - Site Assistance forums, part of the Apple iPad Discussions category; I have been using ipad 2 for over a year and up to a few days ago, have had no problems with formulas in added ...

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 5 of 5
  1. #1
    iPF Noob
    Member #
    218109
    Join Date
    Jun 2012
    Location
    UK
    Posts
    5

    rectify formula malfunctions

    I have been using ipad 2 for over a year and up to a few days ago, have had no problems with formulas in added Excel spreadsheets. Yesterday I added an updated Excel spreadsheet into Numbers as usual. When creating a COUNTA function for column A which had 503 (A2:A504) nonempty cells, instead of giving a result of 503, it gave a result of 1.
    Can anyone help me on this problem

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    Can you add a screenshot of what the function looks like in Numbers?

  4. #3
    iPF Noob
    Member #
    218109
    Join Date
    Jun 2012
    Location
    UK
    Posts
    5
    I have not got the incorrect result showing now as I found an answer to the problem. i downloaded the spreadsheet with the formula already created and it worked ok. i realise that it isn't the real answer but it works for me.

  5. #4
    iPF Noob
    Member #
    218109
    Join Date
    Jun 2012
    Location
    UK
    Posts
    5
    Quote Originally Posted by borryman View Post
    I have not got the incorrect result showing now as I found an answer to the problem. i downloaded the spreadsheet with the formula already created and it worked ok. i realise that it isn't the real answer but it works for me.
    I have thought about your question and i remember what the function looked like thus: =COUNTA(A2:A504). But the function on the spreadsheet I downloaded last had the same but there was a small triangle to the right of A504 which when i touched it, a window came up for preserving rows on start and end but they were all turned off, if you understand all that.

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    It means that instead of selecting a range of cells, you've selected the column. This is a nice feature that only works with some functions. When you use it, it automatically includes all non-header (or footer) cells in a column or row. The advantage is that if you expand the column or row, the new cells are automatically included without the need to adjust the formula.

    To choose the column or row when creating a formula, you tap on the gray bar above or beside the column or row. I'm not sure what the options do (when you tapped on it). I've never fooled with them.

    The formula must either be outside the column or row; or in a header or footer. Otherwise you'll get an error about it be self referential (or something like that).


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. Quickoffice formula help!
    By Gabriel1 in forum iPad Apps
    Replies: 18
    Last Post: 08-02-2012, 05:00 PM
  2. Formula 1
    By Sixtythree in forum iPad 2 Forum
    Replies: 31
    Last Post: 04-01-2012, 04:29 PM
  3. Numbers formula help
    By Abunaixd in forum iWork Forum
    Replies: 16
    Last Post: 03-06-2012, 04:09 PM
  4. Assists with a formula
    By pstar in forum iWork Forum
    Replies: 24
    Last Post: 03-05-2012, 02:32 PM
  5. Help with Numbers formula
    By Jmfocus in forum iWork Forum
    Replies: 30
    Last Post: 08-30-2011, 09:06 PM