Welcome to iPadForums.net Guest - Click Here to Register

Excel Formula Help in Numbers

This is a discussion on Excel Formula Help in Numbers within the Productivity Apps Forum forums, part of the iPad App Store category; I have a formula that works great in Excel, and that I have not been able to re-write it to work in Numbers. Here it ...

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 2 of 2
  1. #1
    iPF Noob
    Member #
    251844
    Join Date
    Oct 2012
    Posts
    1

    Excel Formula Help in Numbers

    I have a formula that works great in Excel, and that I have not been able to re-write it to work in Numbers. Here it is.

    =IF(LEN(B2)>0,SUM(A3:INDIRECT("A"&ROW()+IFERROR(MA TCH("*$",A3:A52,0),50))),"")

    I realize that everone one of these individual formulas are supported in Numbers, it seems to be the nested INDIRECT portion causing the grief. When I try to open this in Numbers I get a message saying the formula is not supported, and it has pasted the last values.

    Is there a way to write this formua to to work in both Excel and Numbers?

    If you are curious, this formula is writen to SUM a variable range of values between BarCodes (containing the $). The value string that needs to be summed can be as short as 1 value between each bar code, and up to 15-20 rows or values between.

    Any Ideas?

    Hoser

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    Off the top of my head I see one problem. The SUM function can only take one variable (sort of); either a range or column/row. To make the INDIRECT function work inside it you'll have to generate the pointer to the entire address, not just half of it. I also suspect that the stuff going on inside the INDIRECT statement will have to be done differently.

    As for the rest, I really don't understand what you are doing well enough to guess at a workable formula. If you can supply a sample sheet I might be able to come up with something.


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. Excel reader that supports my formula
    By Bluescan in forum iPad General Discussions
    Replies: 9
    Last Post: 05-11-2012, 05:31 PM
  2. Numbers formula help
    By Abunaixd in forum iWork Forum
    Replies: 16
    Last Post: 03-06-2012, 04:09 PM
  3. iPad Numbers formula help
    By Zera in forum iWork Forum
    Replies: 12
    Last Post: 09-02-2011, 08:49 PM
  4. Help with Numbers formula
    By Jmfocus in forum iWork Forum
    Replies: 30
    Last Post: 08-30-2011, 09:06 PM
  5. Numbers Formula Instructions
    By Hal05154 in forum iWork Forum
    Replies: 3
    Last Post: 01-23-2011, 03:37 PM

Search tags for this page

how to show excel formulas in numbers ipad

,

ipad excel function

,

numbers app and excel

,

numbers formula help

,

numbers on ipad

Click on a term to search for related topics.