=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..
Bookmarks