View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Navision Navision is offline
external usenet poster
 
Posts: 3
Default Problems with SUMIF in Excel

Thanks,

but it doesnt work. 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 Šifra 1.1.2006 1.2.2006
TROŠKOVI POSLOVANJA 40000 72144 6548
TROŠKOVI PR & MARKETING I PRODAJE 40000 57828 5689
450 Troškovi oglašavanja 40000 5689 859
451 Troškovi PR-a 40000
452 Troškovi istraživanja tržišta 40000 568
453 Troškovi donacija i sponzorstva 40000 458
454 Troškovi tiska plakata, izrade oglasa 40000 5689
455 Troškovi izrade foršpana 40000 56234
456 Fotografiranje,animac.,jinglovi,logotip 40000
457 Institucij.mat.(vizitke,memo,posjet,vre) 40000
Ostali troškovi prodaje i marketinga 40000 0 0
4590 Ostali troškovi prodaje i marketinga 40000 568
4591 Troškovi nagradnih igara-prodaja 40000
4592 Troškovi spikiranja foršpana-Yammat 40000

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