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

Problems with SUMIF()
 

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Navision" wrote in message
oups.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..

Problems with SUMIF()
 

Thanks,

but this is not a solution...

Problems with SUMIF()
 

?????????

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Navision" wrote in message
oups.com...
Thanks,

but this is not a solution...

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

Problems with SUMIF()
 

Try this:

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

Does this help?

Kostis Vezerides