2016-08-31T07:06:11.554627213P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/139d3b3e8b157c1f365f888126269f0902acbaa2
0
0
97587
21859
view1
2
8
0
0
0
0
2
0
0
0
0
0
75
60
true
false
4
9
0
0
0
0
2
0
0
0
0
0
75
60
true
false
Sheet2
1241
0
75
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
false
12632256
false
Lexmark-E352dn
cs
CZ
de
DE
en
US
nl
NL
true
true
3
1
true
1
true
kQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=
false
0
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
COUNTIFS Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple COUNTIFS 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
Salesperson
Exceeded Q1 quota
Exceeded Q2 quota
Exceeded Q3 quota
Data
1
1
TRUE
=COUNTIFS(I1:I10,2006)
2001
pear
Davidoski
Yes
No
1
05/01/11
1
1
TRUE
=COUNTIFS(I1:I10,J1)
2002
pomelo
1999
Burke
Yes
No
2
05/02/11
4
4
TRUE
=COUNTIFS(I1:I10,">=2006")
2003
melon
2000
Sundaram
Yes
3
05/03/11
6
6
TRUE
=COUNTIFS(I1:I10,"<"&J1)
0
2004
0
Levitan
No
Yes
4
05/04/11
3
3
TRUE
=COUNTIFS(I1:I10,K1)
2005
0
5
05/05/11
2
2
TRUE
=COUNTIFS(L1:L5, ">=P")
2006
0
6
05/06/11
4
4
TRUE
=COUNTIFS(L1:L8, ".+")
2007
2002
0
0
TRUE
=COUNTIFS($I$13:$I$15,1)
2008
2001
3
3
TRUE
=COUNTIFS($I$13:$I$15,0)
2009
X
3
3
TRUE
=COUNTIFS($I$13:$I$15,"")
2002
1
1
TRUE
=COUNTIFS(F12,F12)
dfdsf]fdf
1
1
TRUE
=COUNTIFS(F13,F13)
fgdg{fg
1
1
TRUE
=COUNTIFS(F14,F14)
fgsdfg}dfds
1
1
TRUE
=COUNTIFS(F20:F22,"=0")
0
0
TRUE
{=COUNTIFS(IF(A2:A3=1,B2:B3,C2:C3),2)}
2
2
TRUE
{=COUNTIFS(F24:F28,F24:F28)}
7
2
2
result
1
1
TRUE
{=COUNTIFS(F24:F28,F24:F28)}
8
3.5
3.5
2
2
TRUE
{=COUNTIFS(F24:F28,F24:F28)}
4
4
1
1
TRUE
{=COUNTIFS(F24:F28,F24:F28)}
#DIV/0!
1
1
TRUE
{=COUNTIFS(F24:F28,F24:F28)}
0
3.5
0
0
TRUE
=COUNTIFS(O3:O15,Q1)
1
5
5
TRUE
=COUNTIFS(O3:O15,R1)
4
4
TRUE
=COUNTIFS(O3:O15,S1)
Q
5
5
TRUE
=COUNTIFS(O3:O15,T1)
R
5
5
TRUE
=COUNTIFS(O3:O15,U1)
Q
8
8
TRUE
=COUNTIFS(O3:O15,V1)
T
3
3
TRUE
=COUNTIFS(O3:O15,W1)
U
1
1
TRUE
=COUNTIFS(O3:O15,X1)
3
3
TRUE
=COUNTIFS(O3:O15,Y1)
1
1
4
4
TRUE
=COUNTIFS(J30:J35,"")
2
1
1
TRUE
=COUNTIFS(AB2:AD2,"=Yes")
3
2
2
TRUE
=COUNTIFS(AB2:AB5,"=Yes",AC2:AC5,"=Yes")
1
1
1
1
TRUE
=COUNTIFS(AB5:AD5,"=Yes",AB3:AD3,"=Yes")
2
4
4
TRUE
=COUNTIFS(AF2:AF7,"<6",AF2:AF7,">1")
3
2
2
TRUE
=COUNTIFS(AF2:AF7, "<5",AG2:AG7,"<5/3/2011")
2
2
TRUE
=COUNTIFS(AF2:AF7, "<" & AF6,AG2:AG7,"<" & AG4)
4