2016-08-15T16:03:33.128100798P0D1LibreOfficeDev/6.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/24b1827309e7fe4d77108da5732f7f4eddad3ae6 0 0 100358 11833 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 3 17 0 0 0 0 2 0 32 0 0 0 75 60 true false Sheet2 1861 0 75 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false true false 1270 7 false 1 true true false 1 true true true 12632256 true true false true true 1270 3 true cs CZ en US nl NL Generic Printer false kQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAsgAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6QTQARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY= false false true 0 false true false true 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 AVERAGEIFS Function Result TRUE Sheet Result Description 1 TRUE Simple AVERAGEIFS formulas with local references and values Function Expected Correct FunctionString Comment Product Name Sales Revenue book Student First Second Final Type Price Town Number of Bedrooms Garage? year month day value Code Price Rating Number of Reviews 25 25 TRUE =AVERAGEIFS(K2:K6,K2:K6,">=20") pencil 20 65 $35.00 Quiz Exam Cozy Rambler 230000 Issaquah 3 No 2012 12 15 6 2301 1 137.5 137.5 TRUE =AVERAGEIFS(L2:L6,K2:K6,">=20",L2:L6,">70") pen 35 85 Grade Snug Bungalow 197000 Bellevue 2 Yes 2012 4 1 10.4 3405 3.4 10 127.5 127.5 TRUE =AVERAGEIFS(L2:L6,K2:K6,">"&MIN(K2:K6),K2:K6,"<"&MAX(K2:K6)) notebook 20 190 Emilio 75 85 87 Cool Cape Codder 345678 Bellevue 4 Yes 2013 8 15 7 2045 23.5 2.1 12 65 65 TRUE =AVERAGEIFS(L2:L6,J2:J6,"pen.*",K2:K6,"<"&MAX(K2:K6)) book 17 180 Julie 94 80 88 Splendid Split Level 321900 Issaquah 2 Yes 2011 11 1 12 1023 35.6 4.5 45 75 75 TRUE =AVERAGEIFS(P2:P5, P2:P5, ">70", P2:P5, "<90") pencil-case not Hans 86 93 Incomplete Exclusive Tudor 450000 Bellevue 5 Yes 2011 2 14 8 7089 3.8 23 #DIV/0! #DIV/0! TRUE =AVERAGEIFS(Q2:Q5, Q2:Q5, ">95") Frederique Incomplete 75 Classy Colonial 395000 Bellevue 4 No 2010 6 1 15 1123 45.67 4.1 56 87.5 87.5 TRUE =AVERAGEIFS(R2:R5, R2:R5, "<>Incomplete", R2:R5, ">80") 3456 74.5 3.9 9 397839 397839 TRUE =AVERAGEIFS(V2:V7, W2:W7, "Bellevue", X2:X7, ">2",Y2:Y7, "Yes") 1231 97.5 10 230000 230000 TRUE =AVERAGEIFS(V2:V7, W2:W7, "Issaquah", X2:X7, "<=3",Y2:Y7, "No") 5678 2.1 8.20 8.2 TRUE =AVERAGEIFS(AD2:AD7, AA2:AA7, 2012) 9841 4.6 36 8.20 8.2 TRUE =AVERAGEIFS(AD2:AD7, AA2:AA7, 2012, AB2:AB7, ">3") 1089 50 6.00 6 TRUE =AVERAGEIFS(AD2:AD7, AA2:AA7, 2012, AB2:AB7, ">4") A B 8.20 8.2 TRUE =AVERAGEIFS(AD2:AD7, AA2:AA7, 2012, AB2:AB7, ">3", AC2:AC7, "<=15") 1 with leading ' (cell standard) 1 2 40.635 40.635 TRUE =AVERAGEIFS(AI2:AI12,AJ2:AJ12,">3.5",AK2:AK12,">9") numeric 1 (cell standard) 1 1 in cell formatted as text 1 3 cell as text with numeric 1 1 4 4