2016-08-31T20:30:18.285661789P0D1LibreOfficeDev/6.2.0.0.alpha0$Linux_X86_64 LibreOffice_project/49c87270f7176312806d1759967c247a312f0acf 0 0 77267 32328 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 33 0 0 0 0 2 0 0 0 15 0 75 60 true false Sheet2 1194 0 75 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 true true true false false false true true false 0 cs CZ en US nl NL false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn true 3 1 true 1 true wQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA3QAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpEdXBsZXhOb1R1bWJsZQBJbnB1dFNsb3Q6VHJheTEAUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERRQARHVwbGV4TW9kZTo6TG9uZ0VkZ2U= true false false true Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ % / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € . . ??? Page 1 ???(???) 00.00.0000, 00:00:00 Page 1/ 99 COUNTIF Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple COUNTIF formulas with local references and values Function Expected Correct FunctionString Comment 2000 2006 >2006 apple search for 1999 2002 1998 >=1999 >1999 <2001 >0 >=0 0 X 1 1 PRAVDA =COUNTIF(I1:I10;2006) 2001 pear 1 1 PRAVDA =COUNTIF(I1:I10;J1) 2002 pomelo 1999 4 4 PRAVDA =COUNTIF(I1:I10;">=2006") 2003 melon 2000 6 6 PRAVDA =COUNTIF(I1:I10;"<"&J1) 0 2004 0 3 3 PRAVDA =COUNTIF(I1:I10;K1) 2005 0 2 2 PRAVDA =COUNTIF(L1:L5; ">=P") 2006 0 4 4 PRAVDA =COUNTIF(L1:L8; ".+") 2007 2002 0 0 PRAVDA =COUNTIF($I$13:$I$15;1) 2008 2001 3 3 PRAVDA =COUNTIF($I$13:$I$15;0) 2009 X 3 3 PRAVDA =COUNTIF($I$13:$I$15;"") 2002 1 1 PRAVDA =COUNTIF(F12;F12) dfdsf]fdf 1 1 PRAVDA =COUNTIF(F13;F13) fgdg{fg 1 1 PRAVDA =COUNTIF(F14;F14) fgsdfg}dfds 1 1 PRAVDA =COUNTIF(F20:F22;"=0") AOO#97733 0 0 PRAVDA {=COUNTIF(IF(A2:A3=1;B2:B3;C2:C3);2)} AOO#65866 2 2 PRAVDA {=COUNTIF(F24:F28;F24:F28)} AOO#57401 7 2 2 result 2 2 PRAVDA =COUNTIF(I17:J19;J21) AOO#18374 8 3,5 3,5 2 2 PRAVDA =COUNTIF(I17:J19;SMALL(I17:J19;4)) 4 4 1 1 PRAVDA =COUNTIF(O3:O15;O1) AOO#36381 #DIV/0! 2 2 PRAVDA =COUNTIF(O3:O15;P1) 0 3,5 0 0 PRAVDA =COUNTIF(O3:O15;Q1) 1 5 5 PRAVDA =COUNTIF(O3:O15;R1) 4 4 PRAVDA =COUNTIF(O3:O15;S1) Q 5 5 PRAVDA =COUNTIF(O3:O15;T1) R 5 5 PRAVDA =COUNTIF(O3:O15;U1) Q 8 8 PRAVDA =COUNTIF(O3:O15;V1) T 3 3 PRAVDA =COUNTIF(O3:O15;W1) U 1 1 PRAVDA =COUNTIF(O3:O15;X1) 3 3 PRAVDA =COUNTIF(O3:O15;Y1) 1 1 4 4 PRAVDA =COUNTIF(J30:J35;"") Tdf#77039 2 12 12 PRAVDA =COUNTIF(P20:R23;"") tdf#117433 3 2 2 PRAVDA =COUNTIF(N33:N35;"<>7") Tdf#73081 1 1 2 7 3 8 0 1 A00#122187 ghf[fhsd 0 1 fsdf(fdsd 0 1 dfds)fgfgd 0 1,000000 = 2 AOO#123925 4