Welcome to iPadForums.net Guest - Click Here to Register

Sume with conditionals

This is a discussion on Sume with conditionals within the iWork Forum forums, part of the iPad App Store category; Hi, i try to make a control of the money that is use during the month in differents concepts, The thing is that i don't ...

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
Like Tree1Likes
  • 1 Post By twerppoet

Thread: Sume with conditionals

  1. #1
    iPF Noob
    Member #
    291338
    Join Date
    May 2013
    Posts
    4

    Sume with conditionals

    Hi, i try to make a control of the money that is use during the month in differents concepts,

    The thing is that i don't know how to separate this in months in numbers, could you help me?

    I want to separate the things in the table "moneatos" in the Table "tabla 5" for months and concept.

    Thanks
    Attached Thumbnails Attached Thumbnails Sume with conditionals-despeses-demo.pdf  

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,429
    The function you need is SUMIFS. It allows you sum a column or range of cells with two or more conditionals.

    If you check out the example for the SUMIFS function you'll see they give one with three conditional statements. Two of them make sure the row is in the right date range with less than and greater than date conditions of the date column. The third matches test column that would be the same as your concept column.

    You see the function examples by tapping the blue arrow next to each function. You enter conditions by selecting the condition in the function editor and using the "abc" key.

    I'm hoping the language difference doesn't mangle my suggestions beyond use.

    Good luck.

  4. #3
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,429
    Ok. As sometimes happens I couldn't get the problem out of my head until I proved it would work.

    Here is a link to a spreadsheet I put together using your attachment as a template.


    https://www.box.com/s/0wx39ydwm4r13fhb8ckc

    It is not exact. I only did enough to prove the formulas would work, but you should be able to figure out how to complete your own spreadsheet using it as an example.

    Good Luck, again.

  5. #4
    iPF Noob
    Member #
    291338
    Join Date
    May 2013
    Posts
    4
    Thanks a lot, that was the idea, now i have finished the table with your help.

    Thaaaanks!!!

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,429
    No problem. Glad to help. I tackle these kinds of problems because I find them interesting, and I learn a lot myself.

    So, thank you for the challenge.
    J. A. likes this.


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

Search tags for this page

sumewith

Click on a term to search for related topics.