+ Reply to Thread
Results 1 to 6 of 6

Problems with SUMIF()

  1. #1
    Navision
    Guest

    Problems with SUMIF()


    =SUMIF(GLAcc;">='450'";Razdoblje1)-SUMIF(GLAcc;">='45999'";Razdoblje1)

    it doesnot work on Excel 2003 because it doesnot taking first cell
    "450" (text) at all.


    operand >= doesnot work. Please help!


    This is an export file from MBS Navision plans and
    it has predifined formulas in excel. And I can not change it in
    Navision, maybe only in excel. Example:
    Br. racuna GK Ime TC Sifra 1.1.2006 1.2.2006
    TROSKOVI POSLOVANJA 40000 72144 6548
    TROSKOVI PR & MARKETING I PRODAJE 40000 57828 5689
    450 Troskovi oglasavanja 40000 5689 859
    451 Troskovi PR-a 40000
    452 Troskovi istrazivanja trzista 40000 568
    453 Troskovi donacija i sponzorstva 40000 458
    454 Troskovi tiska plakata, izrade oglasa 40000 5689
    455 Troskovi izrade forspana 40000 56234
    456 Fotografiranje,animac.,jinglovi,logotip 40000
    457 Institucij.mat.(vizitke,memo,posjet,vre) 40000
    Ostali troskovi prodaje i marketinga 40000 0 0
    4590 Ostali troskovi prodaje i marketinga 40000 568
    4591 Troskovi nagradnih igara-prodaja 40000
    4592 Troskovi spikiranja forspana-Yammat 40000


    450 is exported txt cell,blanks in first columns are formulas cell..


  2. #2
    Bob Phillips
    Guest

    Re: Problems with SUMIF()

    =SUMIF(GLAcc;">=450";Razdoblje1)-SUMIF(GLAcc;">=45999";Razdoblje1)


    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "Navision" <damir@dignus.hr> wrote in message
    news:1141392882.368757.110810@v46g2000cwv.googlegroups.com...
    >
    > =SUMIF(GLAcc;">='450'";Razdoblje1)-SUMIF(GLAcc;">='45999'";Razdoblje1)
    >
    > it doesnot work on Excel 2003 because it doesnot taking first cell
    > "450" (text) at all.
    >
    >
    > operand >= doesnot work. Please help!
    >
    >
    > This is an export file from MBS Navision plans and
    > it has predifined formulas in excel. And I can not change it in
    > Navision, maybe only in excel. Example:
    > Br. racuna GK Ime TC Sifra 1.1.2006 1.2.2006
    > TROSKOVI POSLOVANJA 40000 72144 6548
    > TROSKOVI PR & MARKETING I PRODAJE 40000 57828 5689
    > 450 Troskovi oglasavanja 40000 5689 859
    > 451 Troskovi PR-a 40000
    > 452 Troskovi istrazivanja trzista 40000 568
    > 453 Troskovi donacija i sponzorstva 40000 458
    > 454 Troskovi tiska plakata, izrade oglasa 40000 5689
    > 455 Troskovi izrade forspana 40000 56234
    > 456 Fotografiranje,animac.,jinglovi,logotip 40000
    > 457 Institucij.mat.(vizitke,memo,posjet,vre) 40000
    > Ostali troskovi prodaje i marketinga 40000 0 0
    > 4590 Ostali troskovi prodaje i marketinga 40000 568
    > 4591 Troskovi nagradnih igara-prodaja 40000
    > 4592 Troskovi spikiranja forspana-Yammat 40000
    >
    >
    > 450 is exported txt cell,blanks in first columns are formulas cell..
    >




  3. #3
    Navision
    Guest

    Re: Problems with SUMIF()

    Thanks,

    but this is not a solution...


  4. #4
    Bob Phillips
    Guest

    Re: Problems with SUMIF()

    ?????????

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "Navision" <damir@dignus.hr> wrote in message
    news:1141394383.793710.162630@u72g2000cwu.googlegroups.com...
    > Thanks,
    >
    > but this is not a solution...
    >




  5. #5
    Navision
    Guest

    Re: Problems with SUMIF()

    the change gives result in a cell 0
    =SUMIF(GLAcc;">=450";Razdoblje1)-SUMIF(GLAcc;">=45999";Razdoblje1)

    450 is text and in a same time first row pointed by formula
    other rows are calculated o.k. only first row is not taken


  6. #6
    vezerid
    Guest

    Re: Problems with SUMIF()

    Try this:

    =SUMPRODUCT(Razdoblje1*--(--LEFT(GLAcc,FIND("
    ",GLAcc)-1)>=450)*--(--LEFT(GLAcc,FIND(" ",GLAcc)-1)<46000)

    Does this help?

    Kostis Vezerides


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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 Engine Friendly URLs by vBSEO 3.6.0 RC 1