Bugetul Secretariatului General al Guvernului / 2018 Buget SGG și instituții finanțate de la bugetul de stat

IF($H$256:$H$923,$H80,S$256:S$923) =SUMIF($H$256:$H$923,$H80,T$256:T$923) =SUMIF($H$256:$H$923,$H80,U$256:U$923) 100204 L81 =CONCATENATE("5001",H81) =LEFT(A81,4) 06 100206 Vauchere de vacanta =SUMIF($H$256:$H$923,$H81,J$256:J$923) =SUMIF($H$256:$H$923,$H81,K$256:K$923) =SUMIF($H$256:$H$923,$H81,L$256:L$923) =SUMIF($H$256:$H$923,$H81,M$256:M$923) =SUMIF($H$256:$H$923,$H81,N$256:N$923) =SUMIF($H$256:$H$923,$H81,O$256:O$923) =SUMIF($H$256:$H$923,$H81,P$256:P$923) =SUMIF($H$256:$H$923,$H81,Q$256:Q$923) =SUMIF($H$256:$H$923,$H81,R$256:R$923) =SUMIF($H$256:$H$923,$H81,S$256:S$923) =SUMIF($H$256:$H$923,$H81,T$256:T$923) =SUMIF($H$256:$H$923,$H81,U$256:U$923) L82 =CONCATENATE("5001",H82) =LEFT(A82,4) 30 100230 Alte drepturi salariale in natura =SUMIF($H$256:$H$923,$H82,J$256:J$923) =SUMIF($H$256:$H$923,$H82,K$256:K$923) =SUMIF($H$256:$H$923,$H82,L$256:L$923) =SUMIF($H$256:$H$923,$H82,M$256:M$923) =SUMIF($H$256:$H$923,$H82,N$256:N$923) =SUMIF($H$256:$H$923,$H82,O$256:O$923) =SUMIF($H$256:$H$923,$H82,P$256:P$923) =SUMIF($H$256:$H$923,$H82,Q$256:Q$923) =SUMIF($H$256:$H$923,$H82,R$256:R$923) =SUMIF($H$256:$H$923,$H82,S$256:S$923) =SUMIF($H$256:$H$923,$H82,T$256:T$923) =SUMIF($H$256:$H$923,$H82,U$256:U$923) 100230 L83 =CONCATENATE("5001",H83) =LEFT(A83,4) 03 1003 Contributii =SUM(J84:J90) =SUM(K84:K90) =SUM(L84:L90) =SUM(M84:M90) =SUM(N84:N90) =SUM(O84:O90) =SUM(P84:P90) =SUM(Q84:Q90) =SUM(R84:R90) =SUM(S84:S90) =SUM(T84:T90) =SUM(U84:U90) 1003 L84 =CONCATENATE("5001",H84) =LEFT(A84,4) 01 100301 Contributii de asigurari sociale de stat =SUMIF($H$256:$H$923,$H84,J$256:J$923) =SUMIF($H$256:$H$923,$H84,K$256:K$923) =SUMIF($H$256:$H$923,$H84,L$256:L$923) =SUMIF($H$256:$H$923,$H84,M$256:M$923) =SUMIF($H$256:$H$923,$H84,N$256:N$923) =SUMIF($H$256:$H$923,$H84,O$256:O$923) =SUMIF($H$256:$H$923,$H84,P$256:P$923) =SUMIF($H$256:$H$923,$H84,Q$256:Q$923) =SUMIF($H$256:$H$923,$H84,R$256:R$923) =SUMIF($H$256:$H$923,$H84,S$256:S$923) =SUMIF($H$256:$H$923,$H84,T$256:T$923) =SUMIF($H$256:$H$923,$H84,U$256:U$923) 100301 L85 =CONCATENATE("5001",H85) =LEFT(A85,4) 03 100302 Contributii de asigurari de şomaj =SUMIF($H$256:$H$923,$H85,J$256:J$923) =SUMIF($H$256:$H$923,$H85,K$256:K$923) =SUMIF($H$256:$H$923,$H85,L$256:L$923) =SUMIF($H$256:$H$923,$H85,M$256:M$923) =SUMIF($H$256:$H$923,$H85,N$256:N$923) =SUMIF($H$256:$H$923,$H85,O$256:O$923) =SUMIF($H$256:$H$923,$H85,P$256:P$923) =SUMIF($H$256:$H$923,$H85,Q$256:Q$923) =SUMIF($H$256:$H$923,$H85,R$256:R$923) =SUMIF($H$256:$H$923,$H85,S$256:S$923) =SUMIF($H$256:$H$923,$H85,T$256:T$923) =SUMIF($H$256:$H$923,$H85,U$256:U$923) 100302 L86 =CONCATENATE("5001",H86) =LEFT(A86,4) 03 100303 Contributii de asigurari sociale de sanatate =SUMIF($H$256:$H$923,$H86,J$256:J$923) =SUMIF($H$256:$H$923,$H86,K$256:K$923) =SUMIF($H$256:$H$923,$H86,L$256:L$923) =SUMIF($H$256:$H$923,$H86,M$256:M$923) =SUMIF($H$256:$H$923,$H86,N$256:N$923) =SUMIF($H$256:$H$923,$H86,O$256:O$923) =SUMIF($H$256:$H$923,$H86,P$256:P$923) =SUMIF($H$256:$H$923,$H86,Q$256:Q$923) =SUMIF($H$256:$H$923,$H86,R$256:R$923) =SUMIF($H$256:$H$923,$H86,S$256:S$923) =SUMIF($H$256:$H$923,$H86,T$256:T$923) =SUMIF($H$256:$H$923,$H86,U$256:U$923) 100303 L87 =CONCATENATE("5001",H87) =LEFT(A87,4) 04 100304 Contributii de asigurari pentru accidente de munca si boli profesionale =SUMIF($H$256:$H$923,$H87,J$256:J$923) =SUMIF($H$256:$H$923,$H87,K$256:K$923) =SUMIF($H$256:$H$923,$H87,L$256:L$923) =SUMIF($H$256:$H$923,$H87,M$256:M$923) =SUMIF($H$256:$H$923,$H87,N$256:N$923) =SUMIF($H$256:$H$923,$H87,O$256:O$923) =SUMIF($H$256:$H$923,$H87,P$256:P$923) =SUMIF($H$256:$H$923,$H87,Q$256:Q$923) =SUMIF($H$256:$H$923,$H87,R$256:R$923) =SUMIF($H$256:$H$923,$H87,S$256:S$923) =SUMIF($H$256:$H$923,$H87,T$256:T$923) =SUMIF($H$256:$H$923,$H87,U$256:U$923) 100304 L88 =CONCATENATE("5001",H88) =LEFT(A88,4) 06 100306 Contributii pentru concedii si indemnizatii =SUMIF($H$256:$H$923,$H88,J$256:J$923) =SUMIF($H$256:$H$923,$H88,K$256:K$923) =SUMIF($H$256:$H$923,$H88,L$256:L$923) =SUMIF($H$256:$H$923,$H88,M$256:M$923) =SUMIF($H$256:$H$923,$H88,N$256:N$923) =SUMIF($H$256:$H$923,$H88,O$256:O$923) =SUMIF($H$256:$H$923,$H88,P$256:P$923) =SUMIF($H$256:$H$923,$H88,Q$256:Q$923) =SUMIF($H$256:$H$923,$H88,R$256:R$923) =SUMIF($H$256:$H$923,$H88,S$256:S$923) =SUMIF($H$256:$H$923,$H88,T$256:T$923) =SUMIF($H$256:$H$923,$H88,U$256:U$923) 100306 L89 =CONCATENATE("5001",H89) =LEFT(A89,4) 07 100307 Contributia asiguratorie pentru munca =SUMIF($H$256:$H$923,$H89,J$256:J$923) =SUMIF($H$256:$H$923,$H89,K$256:K$923) =SUMIF($H$256:$H$923,$H89,L$256:L$923) =SUMIF($H$256:$H$923,$H89,M$256:M$923) =SUMIF($H$256:$H$923,$H89,N$256:N$923) =SUMIF($H$256:$H$923,$H89,O$256:O$923) =SUMIF($H$256:$H$923,$H89,P$256:P$923) =SUMIF($H$256:$H$923,$H89,Q$256:Q$923) =SUMIF($H$256:$H$923,$H89,R$256:R$923) =SUMIF($H$256:$H$923,$H89,S$256:S$923) =SUMIF($H$256:$H$923,$H89,T$256:T$923) =SUMIF($H$256:$H$923,$H89,U$256:U$923) 100307 L90 5001 08 100308 Contributii platite de angajator in numele angajatului =SUMIF($H$256:$H$923,$H90,J$256:J$923) =SUMIF($H$256:$H$923,$H90,K$256:K$923) =SUMIF($H$256:$H$923,$H90,L$256:L$923) =SUMIF($H$256:$H$923,$H90,M$256:M$923) =SUMIF($H$256:$H$923,$H90,N$256:N$923) =SUMIF($H$256:$H$923,$H90,O$256:O$923) =SUMIF($H$256:$H$923,$H90,P$256:P$923) =SUMIF($H$256:$H$923,$H90,Q$256:Q$923) =SUMIF($H$256:$H$923,$H90,R$256:R$923) =SUMIF($H$256:$H$923,$H90,S$256:S$923) =SUMIF($H$256:$H$923,$H90,T$256:T$923) =SUMIF($H$256:$H$923,$H90,U$256:U$923) 100308 L91 =CONCATENATE("5001",H91) =LEFT(A91,4) 20 20 TITLUL II BUNURI ŞI SERVICII =J92+J103+J104+J106+J109+J112+SUM(J115:J123) =K92+K103+K104+K106+K109+K112+SUM(K115:K123) =L92+L103+L104+L106+L109+L112+SUM(L115:L123) =M92+M103+M104+M106+M109+M112+SUM(M115:M123) =N92+N103+N104+N106+N109+N112+SUM(N115:N123) =O92+O103+O104+O106+O109+O112+SUM(O115:O123) =P92+P103+P104+P106+P109+P112+SUM(P115:P123) =Q92+Q103+Q104+Q106+Q109+Q112+SUM(Q115:Q123) =R92+R103+R104+R106+R109+R112+SUM(R115:R123) =S92+S103+S104+S106+S109+S112+SUM(S115:S123) =T92+T103+T104+T106+T109+T112+SUM(T115:T123) =U92+U103+U104+U106+U109+U112+SUM(U115:U123) 20 L92 =CONCATENATE("5001",H92) =LEFT(A92,4) 01 2001 Bunuri si servicii =SUM(J93:J102) =SUM(K93:K102) =SUM(L93:L102) =SUM(M93:M102) =SUM(N93:N102) =SUM(O93:O102) =SUM(P93:P102) =SUM(Q93:Q102) =SUM(R93:R102) =SUM(S93:S102) =SUM(T93:T102) =SUM(U93:U102) 2001 L93 =CONCATENATE("5001",H93) =LEFT(A93,4) 01 200101 Furnituri de birou =SUMIF($H$256:$H$923,$H93,J$256:J$923) =SUMIF($H$256:$H$923,$H93,K$256:K$923) =SUMIF($H$256:$H$923,$H93,L$256:L$923) =SUMIF($H$256:$H$923,$H93,M$256:M$923) =SUMIF($H$256:$H$923,$H93,N$256:N$923) =SUMIF($H$256:$H$923,$H93,O$256:O$923) =SUMIF($H$256:$H$923,$H93,P$256:P$923) =SUMIF($H$256:$H$923,$H93,Q$256:Q$923) =SUMIF($H$256:$H$923,$H93,R$256:R$923) =SUMIF($H$256:$H$923,$H93,S$256:S$923) =SUMIF($H$256:$H$923,$H93,T$256:T$923) =SUMIF($H$256:$H$923,$H93,U$256:U$923) 200101 L94 =CONCATENATE("5001",H94) =LEFT(A94,4) 02 200102 Materiale pentru curatenie =SUMIF($H$256:$H$923,$H94,J$256:J$923) =SUMIF($H$256:$H$923,$H94,K$256:K$923) =SUMIF($H$256:$H$923,$H94,L$256:L$923) =SUMIF($H$256:$H$923,$H94,M$256:M$923) =SUMIF($H$256:$H$923,$H94,N$256:N$923) =SUMIF($H$256:$H$923,$H94,O$256:O$923) =SUMIF($H$256:$H$923,$H94,P$256:P$923) =SUMIF($H$256:$H$923,$H94,Q$256:Q$923) =SUMIF($H$256:$H$923,$H94,R$256:R$923) =SUMIF($H$256:$H$923,$H94,S$256:S$923) =SUMIF($H$256:$H$923,$H94,T$256:T$923) =SUMIF($H$256:$H$923,$H94,U$256:U$923) 200102 L95 =CONCATENATE("5001",H95) =LEFT(A95,4) 03 200103 Incalzit, iluminat si forta motrica =SUMIF($H$256:$H$923,$H95,J$256:J$923) =SUMIF($H$256:$H$923,$H95,K$256:K$923) =SUMIF($H$256:$H$923,$H95,L$256:L$923) =SUMIF($H$256:$H$923,$H95,M$256:M$923) =SUMIF($H$256:$H$923,$H95,N$256:N$923) =SUMIF($H$256:$H$923,$H95,O$256:O$923) =SUMIF($H$256:$H$923,$H95,P$256:P$923) =SUMIF($H$256:$H$923,$H95,Q$256:Q$923) =SUMIF($H$256:$H$923,$H95,R$256:R$923) =SUMIF($H$256:$H$923,$H95,S$256:S$923) =SUMIF($H$256:$H$923,$H95,T$256:T$923) =SUMIF($H$256:$H$923,$H95,U$256:U$923) 200103 L96 =CONCATENATE("5001",H96) =LEFT(A96,4) 04 200104 Apa, canal si salubritate =SUMIF($H$256:$H$923,$H96,J$256:J$923) =SUMIF($H$256:$H$923,$H96,K$256:K$923) =SUMIF($H$256:$H$923,$H96,L$256:L$923) =SUMIF($H$256:$H$923,$H96,M$256:M$923) =SUMIF($H$256:$H$923,$H96,N$256:N$923) =SUMIF($H$256:$H$923,$H96,O$256:O$923) =SUMIF($H$256:$H$923,$H96,P$256:P$923) =SUMIF($H$256:$H$923,$H96,Q$256:Q$923) =SUMIF($H$256:$H$923,$H96,R$256:R$923) =SUMIF($H$256:$H$923,$H96,S$256:S$923) =SUMIF($H$256:$H$923,$H96,T$256:T$923) =SUMIF($H$256:$H$923,$H96,U$256:U$923) 200104 L97 =CONCATENATE("5001",H97) =LEFT(A97,4) 05 200105 Carburanti si lubrifianti =SUMIF($H$256:$H$923,$H97,J$256:J$923) =SUMIF($H$256:$H$923,$H97,K$256:K$923) =SUMIF($H$256:$H$923,$H97,L$256:L$923) =SUMIF($H$256:$H$923,$H97,M$256:M$923) =SUMIF($H$256:$H$923,$H97,N$256:N$923) =SUMIF($H$256:$H$923,$H97,O$256:O$923) =SUMIF($H$256:$H$923,$H97,P$256:P$923) =SUMIF($H$256:$H$923,$H97,Q$256:Q$923) =SUMIF($H$256:$H$923,$H97,R$256:R$923) =SUMIF($H$256:$H$923,$H97,S$256:S$923) =SUMIF($H$256:$H$923,$H97,T$256:T$923) =SUMIF($H$256:$H$923,$H97,U$256:U$923) 200105 L98 =CONCATENATE("5001",H98) =LEFT(A98,4) 06 200106 Piese de schimb =SUMIF($H$256:$H$923,$H98,J$256:J$923) =SUMIF($H$256:$H$923,$H98,K$256:K$923) =SUMIF($H$256:$H$923,$H98,L$256:L$923) =SUMIF($H$256:$H$923,$H98,M$256:M$923) =SUMIF($H$256:$H$923,$H98,N$256:N$923) =SUMIF($H$256:$H$923,$H98,O$256:O$923) =SUMIF($H$256:$H$923,$H98,P$256:P$923) =SUMIF($H$256:$H$923,$H98,Q$256:Q$923) =SUMIF($H$256:$H$923,$H98,R$256:R$923) =SUMIF($H$256:$H$923,$H98,S$256:S$923) =SUMIF($H$256:$H$923,$H98,T$256:T$923) =SUMIF($H$256:$H$923,$H98,U$256:U$923) 200106 L99 =CONCATENATE("5001",H99) =LEFT(A99,4) 07 200107 Transport =SUMIF($H$256:$H$923,$H99,J$256:J$923) =SUMIF($H$256:$H$923,$H99,K$256:K$923) =SUMIF($H$256:$H$923,$H99,L$256:L$923) =SUMIF($H$256:$H$923,$H99,M$256:M$923) =SUMIF($H$256:$H$923,$H99,N$256:N$923) =SUMIF($H$256:$H$923,$H99,O$256:O$923) =SUMIF($H$256:$H$923,$H99,P$256:P$923) =SUMIF($H$256:$H$923,$H99,Q$256:Q$923) =SUMIF($H$256:$H$923,$H99,R$256:R$923) =SUMIF($H$256:$H$923,$H99,S$256:S$923) =SUMIF($H$256:$H$923,$H99,T$256:T$923) =SUMIF($H$256:$H$923,$H99,U$256:U$923) 200107 L100 =CONCATENATE("5001",H100) =LEFT(A100,4) 08 200108 Posta, telecomunicatii, radio, tv, internet =SUMIF($H$256:$H$923,$H100,J$256:J$923) =SUMIF($H$256:$H$923,$H100,K$256:K$923) =SUMIF($H$256:$H$923,$H100,L$256:L$923) =SUMIF($H$256:$H$923,$H100,M$256:M$923) =SUMIF($H$256:$H$923,$H100,N$256:N$923) =SUMIF($H$256:$H$923,$H100,O$256:O$923) =SUMIF($H$256:$H$923,$H100,P$256:P$923) =SUMIF($H$256:$H$923,$H100,Q$256:Q$923) =SUMIF($H$256:$H$923,$H100,R$256:R$923) =SUMIF($H$256:$H$923,$H100,S$256:S$923) =SUMIF($H$256:$H$923,$H100,T$256:T$923) =SUMIF($H$256:$H$923,$H100,U$256:U$923) 200108 L101 =CONCATENATE("5001",H101) =LEFT(A101,4) 09 200109 Materiale si prestari de servicii cu caracter functional =SUMIF($H$256:$H$923,$H101,J$256:J$923) =SUMIF($H$256:$H$923,$H101,K$256:K$923) =SUMIF($H$256:$H$923,$H101,L$256:L$923) =SUMIF($H$256:$H$923,$H101,M$256:M$923) =SUMIF($H$256:$H$923,$H101,N$256:N$923) =SUMIF($H$256:$H$923,$H101,O$256:O$923) =SUMIF($H$256:$H$923,$H101,P$256:P$923) =SUMIF($H$256:$H$923,$H101,Q$256:Q$923) =SUMIF($H$256:$H$923,$H101,R$256:R$923) =SUMIF($H$256:$H$923,$H101,S$256:S$923) =SUMIF($H$256:$H$923,$H101,T$256:T$923) =SUMIF($H$256:$H$923,$H101,U$256:U$923) 200109 L102 =CONCATENATE("5001",H102) =LEFT(A102,4) 30 200130 Alte bunuri si servicii pentru intretinere si functionare =SUMIF($H$256:$H$923,$H102,J$256:J$923) =SUMIF($H$256:$H$923,$H102,K$256:K$923) =SUMIF($H$256:$H$923,$H102,L$256:L$923) =SUMIF($H$256:$H$923,$H102,M$256:M$923) =SUMIF($H$256:$H$923,$H102,N$256:N$923) =SUMIF($H$256:$H$923,$H102,O$256:O$923) =SUMIF($H$256:$H$923,$H102,P$256:P$923) =SUMIF($H$256:$H$923,$H102,Q$256:Q$923) =SUMIF($H$256:$H$923,$H102,R$256:R$923) =SUMIF($H$256:$H$923,$H102,S$256:S$923) =SUMIF($H$256:$H$923,$H102,T$256:T$923) =SUMIF($H$256:$H$923,$H102,U$256:U$923) 200130 L103 =CONCATENATE("5001",H103) =LEFT(A103,4) 02 2002 Reparatii curente =SUMIF($H$256:$H$923,$H103,J$256:J$923) =SUMIF($H$256:$H$923,$H103,K$256:K$923) =SUMIF($H$256:$H$923,$H103,L$256:L$923) =SUMIF($H$256:$H$923,$H103,M$256:M$923) =SUMIF($H$256:$H$923,$H103,N$256:N$923) =SUMIF($H$256:$H$923,$H103,O$256:O$923) =SUMIF($H$256:$H$923,$H103,P$256:P$923) =SUMIF($H$256:$H$923,$H103,Q$256:Q$923) =SUMIF($H$256:$H$923,$H103,R$256:R$923) =SUMIF($H$256:$H$923,$H103,S$256:S$923) =SUMIF($H$256:$H$923,$H103,T$256:T$923) =SUMIF($H$256:$H$923,$H103,U$256:U$923) 2002 L104 =CONCATENATE("5001",H104) =LEFT(A104,4) 03 2003 Hrana =J105 =K105 =L105 =M105 =N105 =O105 =P105 =Q105 =R105 =S105 =T105 =U105 2003 L105 =CONCATENATE("5001",H105) =LEFT(A105,4) 01 200301 Hrana pentru oameni =SUMIF($H$256:$H$923,$H105,J$256:J$923) =SUMIF($H$256:$H$923,$H105,K$256:K$923) =SUMIF($H$256:$H$923,$H105,L$256:L$923) =SUMIF($H$256:$H$923,$H105,M$256:M$923) =SUMIF($H$256:$H$923,$H105,N$256:N$923) =SUMIF($H$256:$H$923,$H105,O$256:O$923) =SUMIF($H$256:$H$923,$H105,P$256:P$923) =SUMIF($H$256:$H$923,$H105,Q$256:Q$923) =SUMIF($H$256:$H$923,$H105,R$256:R$923) =SUMIF($H$256:$H$923,$H105,S$256:S$923) =SUMIF($H$256:$H$923,$H105,T$256:T$923) =SUMIF($H$256:$H$923,$H105,U$256:U$923) 200301 L106 =CONCATENATE("5001",H106) =LEFT(A106,4) 04 2004 Medicamente si materiale sanitare =SUM(J107:J108) =SUM(K107:K108) =SUM(L107:L108) =SUM(M107:M108) =SUM(N107:N108) =SUM(O107:O108) =SUM(P107:P108) =SUM(Q107:Q108) =SUM(R107:R108) =SUM(S107:S108) =SUM(T107:T108) =SUM(U107:U108) 2004 L107 =CONCATENATE("5001",H107) =LEFT(A107,4) 01 200401 Medicamente =SUMIF($H$256:$H$923,$H107,J$256:J$923) =SUMIF($H$256:$H$923,$H107,K$256:K$923) =SUMIF($H$256:$H$923,$H107,L$256:L$923) =SUMIF($H$256:$H$923,$H107,M$256:M$923) =SUMIF($H$256:$H$923,$H107,N$256:N$923) =SUMIF($H$256:$H$923,$H107,O$256:O$923) =SUMIF($H$256:$H$923,$H107,P$256:P$923) =SUMIF($H$256:$H$923,$H107,Q$256:Q$923) =SUMIF($H$256:$H$923,$H107,R$256:R$923) =SUMIF($H$256:$H$923,$H107,S$256:S$923) =SUMIF($H$256:$H$923,$H107,T$256:T$923) =SUMIF($H$256:$H$923,$H107,U$256:U$923) 200401 L108 =CONCATENATE("5001",H108) =LEFT(A108,4) 03 200403 Reactivi =SUMIF($H$256:$H$923,$H108,J$256:J$923) =SUMIF($H$256:$H$923,$H108,K$256:K$923) =SUMIF($H$256:$H$923,$H108,L$256:L$923) =SUMIF($H$256:$H$923,$H108,M$256:M$923) =SUMIF($H$256:$H$923,$H108,N$256:N$923) =SUMIF($H$256:$H$923,$H108,O$256:O$923) =SUMIF($H$256:$H$923,$H108,P$256:P$923) =SUMIF($H$256:$H$923,$H108,Q$256:Q$923) =SUMIF($H$256:$H$923,$H108,R$256:R$923) =SUMIF($H$256:$H$923,$H108,S$256:S$923) =SUMIF($H$256:$H$923,$H108,T$256:T$923) =SUMIF($H$256:$H$923,$H108,U$256:U$923) 200403 L109 =CONCATENATE("5001",H109) =LEFT(A109,4) 05 2005 Bunuri de natura obiectelor de inventar =SUM(J110:J111) =SUM(K110:K111) =SUM(L110:L111) =SUM(M110:M111) =SUM(N110:N111) =SUM(O110:O111) =SUM(P110:P111) =SUM(Q110:Q111) =SUM(R110:R111) =SUM(S110:S111) =SUM(T110:T111) =SUM(U110:U111) 2005 L110 =CONCATENATE("5001",H110) =LEFT(A110,4) 01 200501 Uniforme si echipament =SUMIF($H$256:$H$923,$H110,J$256:J$923) =SUMIF($H$256:$H$923,$H110,K$256:K$923) =SUMIF($H$256:$H$923,$H110,L$256:L$923) =SUMIF($H$256:$H$923,$H110,M$256:M$923) =SUMIF($H$256:$H$923,$H110,N$256:N$923) =SUMIF($H$256:$H$923,$H110,O$256:O$923) =SUMIF($H$256:$H$923,$H110,P$256:P$923) =SUMIF($H$256:$H$923,$H110,Q$256:Q$923) =SUMIF($H$256:$H$923,$H110,R$256:R$923) =SUMIF($H$256:$H$923,$H110,S$256:S$923) =SUMIF($H$256:$H$923,$H110,T$256:T$923) =SUMIF($H$256:$H$923,$H110,U$256:U$923) 200501 L111 =CONCATENATE("5001",H111) =LEFT(A111,4) 30 200530 Alte obiecte de inventar =SUMIF($H$256:$H$923,$H111,J$256:J$923) =SUMIF($H$256:$H$923,$H111,K$256:K$923) =SUMIF($H$256:$H$923,$H111,L$256:L$923) =SUMIF($H$256:$H$923,$H111,M$256:M$923) =SUMIF($H$256:$H$923,$H111,N$256:N$923) =SUMIF($H$256:$H$923,$H111,O$256:O$923) =SUMIF($H$256:$H$923,$H111,P$256:P$923) =SUMIF($H$256:$H$923,$H111,Q$256:Q$923) =SUMIF($H$256:$H$923,$H111,R$256:R$923) =SUMIF($H$256:$H$923,$H111,S$256:S$923) =SUMIF($H$256:$H$923,$H111,T$256:T$923) =SUMIF($H$256:$H$923,$H111,U$256:U$923) 200530 L112 =CONCATENATE("5001",H112) =LEFT(A112,4) 06 2006 Deplasari, detasari, transferari =SUM(J113:J114) =SUM(K113:K114) =SUM(L113:L114) =SUM(M113:M114) =SUM(N113:N114) =SUM(O113:O114) =SUM(P113:P114) =SUM(Q113:Q114) =SUM(R113:R114) =SUM(S113:S114) =SUM(T113:T114) =SUM(U113:U114) 2006 L113 =CONCATENATE("5001",H113) =LEFT(A113,4) 01 200601 Deplasari interne, detasari, transferari =SUMIF($H$256:$H$923,$H113,J$256:J$923) =SUMIF($H$256:$H$923,$H113,K$256:K$923) =SUMIF($H$256:$H$923,$H113,L$256:L$923) =SUMIF($H$256:$H$923,$H113,M$256:M$923) =SUMIF($H$256:$H$923,$H113,N$256:N$923) =SUMIF($H$256:$H$923,$H113,O$256:O$923) =SUMIF($H$256:$H$923,$H113,P$256:P$923) =SUMIF($H$256:$H$923,$H113,Q$256:Q$923) =SUMIF($H$256:$H$923,$H113,R$256:R$923) =SUMIF($H$256:$H$923,$H113,S$256:S$923) =SUMIF($H$256:$H$923,$H113,T$256:T$923) =SUMIF($H$256:$H$923,$H113,U$256:U$923) 200601 L114 =CONCATENATE("5001",H114) =LEFT(A114,4) 02 200602 Deplasari in strainatate =SUMIF($H$256:$H$923,$H114,J$256:J$923) =SUMIF($H$256:$H$923,$H114,K$256:K$923) =SUMIF($H$256:$H$923,$H114,L$256:L$923) =SUMIF($H$256:$H$923,$H114,M$256:M$923) =SUMIF($H$256:$H$923,$H114,N$256:N$923) =SUMIF($H$256:$H$923,$H114,O$256:O$923) =SUMIF($H$256:$H$923,$H114,P$256:P$923) =SUMIF($H$256:$H$923,$H114,Q$256:Q$923) =SUMIF($H$256:$H$923,$H114,R$256:R$923) =SUMIF($H$256:$H$923,$H114,S$256:S$923) =SUMIF($H$256:$H$923,$H114,T$256:T$923) =SUMIF($H$256:$H$923,$H114,U$256:U$923) 200602 L115 =CONCATENATE("5001",H115) =LEFT(A115,4) 09 2009 Materiale de laborator =SUMIF($H$256:$H$923,$H115,J$256:J$923) =SUMIF($H$256:$H$923,$H115,K$256:K$923) =SUMIF($H$256:$H$923,$H115,L$256:L$923) =SUMIF($H$256:$H$923,$H115,M$256:M$923) =SUMIF($H$256:$H$923,$H115,N$256:N$923) =SUMIF($H$256:$H$923,$H115,O$256:O$923) =SUMIF($H$256:$H$923,$H115,P$256:P$923) =SUMIF($H$256:$H$923,$H115,Q$256:Q$923) =SUMIF($H$256