{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"tabela cenovnik",null,null,null,null,"osnovna tabela"]
[null,"vrsta","cena",null,null,null,"vrste","ukupna cena","Primer","FilterXML","UDF"]
[null,"kl",150,null,null,null,"kl, as",250,{"$f":"SUMIFS(C5:C10,B5:B10,\"kl\")+SUMIFS(C5:C10,B5:B10,\"as\")","v":250},{"$f":"SUM(TRANSPOSE(VLOOKUP(_xlfn.FILTERXML(\n\"<t><s>\"&\nSUBSTITUTE(\nG5,\n\",\",\n\"</s><s>\"\n)&\"</s></t>\",\n\"//s\"\n), $B$5:$C$9,2, FALSE)))","v":250},{"$f":"SumCena(G5, $B$5:$C$9)","v":250}]
[null,"sd",200,null,null,null,"kl, okt, sd",470,{"$f":"SUMIFS(C5:C10,B5:B10,\"kl\")+SUMIFS(C5:C10,B5:B10,\"okt\")+SUMIFS(C5:C10,B5:B10,\"sd\")","v":470},{"$f":"SUM(TRANSPOSE(VLOOKUP(_xlfn.FILTERXML(\n\"<t><s>\"&\nSUBSTITUTE(\nG6,\n\",\",\n\"</s><s>\"\n)&\"</s></t>\",\n\"//s\"\n), $B$5:$C$9,2, FALSE)))","v":470},{"$f":"SumCena(G6, $B$5:$C$9)","v":470},"ukupna cena je zbir cena koje zadovoljavaju kriterijum"]
[null,"trk",250,null,null,null,"sd",200,{"$f":"SUMIFS(C5:C10,B5:B10,\"sd\")","v":200},{"$f":"SUM(TRANSPOSE(VLOOKUP(_xlfn.FILTERXML(\n\"<t><s>\"&\nSUBSTITUTE(\nG7,\n\",\",\n\"</s><s>\"\n)&\"</s></t>\",\n\"//s\"\n), $B$5:$C$9,2, FALSE)))","v":200},200]
[null,"as",100,null,null,null,"test, as",null,null,null,100]
[null,"okt",120,null,null,null,"sd, okt",null,null,null,320]
[null,"itd"]
[]
[]
[]
[null,null,null,null,null,null,"kriterijumi u jednoj ćeliji, odvojeni zarezom"]
[]
[]
[null,null,"razdvajanje kriterijuma",null,null,null,"kl, okt, sd",null,null,null,{"$f":"LEFT(G17,SEARCH(\",\",G17)-1)","v":"kl"},{"$f":"IFERROR(MID(G17,SEARCH(\",\",G17)+1,SEARCH(\",\",G17,SEARCH(\",\",G17)+1)-SEARCH(\",\",G17)),\"\")","v":" okt,"},{"$f":"IF(LEN(G17)-LEN(SUBSTITUTE(G17,\",\",\"\"))=1,RIGHT(G17,LEN(G17)-SEARCH(\",\",G17)),RIGHT(G17,LEN(G17)-SEARCH(\",\",G17,SEARCH(\",\",G17)+1)))","v":" sd"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM({150,100})","v":250}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}