Sume with conditionals

Discussion in 'iWork Forum' started by kobolt, May 20, 2013.

  1. kobolt
    Offline

    kobolt iPF Noob

    Joined:
    May 20, 2013
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    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 Files:

  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,191
    Thanks Received:
    1,944
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,146 / 1
    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.
  3. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,191
    Thanks Received:
    1,944
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,146 / 1
    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.
  4. kobolt
    Offline

    kobolt iPF Noob

    Joined:
    May 20, 2013
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Thanks a lot, that was the idea, now i have finished the table with your help.

    Thaaaanks!!!
  5. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,191
    Thanks Received:
    1,944
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,146 / 1
    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.
    • Like Like x 1

Share This Page

Search tags for this page

sumewith