2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/709f49bce86d2df4154d8075818f57cacfecb401 0 0 22009 4261 view1 1 7 0 0 0 0 2 0 0 0 0 0 80 60 true false 2 30 0 0 0 0 2 0 0 0 0 0 80 60 true false Sheet2 1048 0 80 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true true true false 12632256 false Generic Printer en US 3 1 true 1 true lQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAtgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKRHVwbGV4Ok5vbmUAUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € WAHR WAHR FALSCH $ - $ € - € € - € / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € % : : : : : : - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 SUMIF Function Result TRUE Sheet Result Description 1 TRUE Simple SUMIF formulas with local references and values Function Expected Correct FunctionString Comment 1 Paid 1 10 a Property Value Commission Data Category Food Sales 6 6 TRUE =SUMIF(I1:I5,"unpaid",H1:H5) 2 Unpaid 2 20 x 100000 7000 250000 Vegetables Tomatoes 2300 1 26 26 TRUE =SUMIF(L1:L11,10,K1:K11) 3 Paid 3 20 x 200000 14000 Vegetables Celery 5500 A 10 26 26 TRUE =SUMIF(M1:M11,"a",K1:K11) 4 Unpaid 4 10 a 300000 21000 Fruits Oranges 800 B 100 26 26 TRUE =SUMIF(N1:N11,"a",K1:K11) 5 Paid 5 11 x 400000 28000 Butter 400 C 1000 26 26 TRUE =SUMIF(O1:O11,"",K1:K11) -3 6 21 x Formula Description Result Vegetables Carrots 4200 10000 26 26 TRUE =SUMIF(P1:P11," ",K1:K11) -2 7 20 x Sum of the commissions for property values over 160,000. $ 63,000.00 Fruits Apples 1200 26 26 TRUE =SUMIF(O1:O11,"=",K1:K11) 8 11 x Sum of the property values over 160,000. $ 900,000.00 Formula Description Result 40 40 TRUE =SUMIF(O1:O11,"<>",K1:K11) 9 12 x Sum of the commissions for property values equal to 300,000. $ 21,000.00 Sum of the sales of all foods in the "Fruits" category. $ 2,000.00 63000 63000 TRUE =SUMIF(R2:R5,">160000",S2:S5) 10 a Sum of the commissions for property values greater than the value in C2. $ 49,000.00 Sum of the sales of all foods in the "Vegetables" category. $ 12,000.00 900000 900000 TRUE =SUMIF(R2:R5,">160000") 11 10 a 21000 21000 TRUE =SUMIF(R2:R5,300000,S2:S5) Sum of the sales of all foods that do not have a category specified. $ 400.00 49000 49000 TRUE =SUMIF(R2:R5,">" & T2,S2:S5) 2000 2000 TRUE =SUMIF(V2:V7,"Fruits",X2:X7) 12000 12000 TRUE =SUMIF(V2:V7,"Vegetables",X2:X7) 400 400 TRUE =SUMIF(V2:V7,"",X2:X7) -5 -5 TRUE =SUMIF(H1:H7,"<0") Err:511 Err:511 TRUE =SUMIF(H2:H8) 100 100 TRUE =SUMIF(Z2:Z6,"=B",AA2:AA6) 11011 11011 TRUE =SUMIF(Z2:Z6,"<>B",AA2:AA6) 10 10 TRUE =SUMIF(Z2:Z6,"<B",AA2:AA6) 1000 1000 TRUE =SUMIF(Z2:Z6,">B",AA2:AA6) 110 110 TRUE =SUMIF(Z2:Z6,"<=B",AA2:AA6) 1100 1100 TRUE =SUMIF(Z2:Z6,">=B",AA2:AA6) 10001 10001 TRUE =SUMIF(Z2:Z6,"=",AA2:AA6) 1110 1110 TRUE =SUMIF(Z2:Z6,"<>",AA2:AA6) 0 0 TRUE =SUMIF(Z2:Z6,"<",AA2:AA6) 1110 1110 TRUE =SUMIF(Z2:Z6,">",AA2:AA6) 0 0 TRUE =SUMIF(Z2:Z6,"<=",AA2:AA6) 1110 1110 TRUE =SUMIF(Z2:Z6,">=",AA2:AA6) 4 O5 yes 1 no 2 yes 3