excel表格中的条件计数及条件求和

狠ﾉｮ g・
杣 5h ﾂ I/{u ｭ 4 ｨｮﾗ ・ｵ 7・・ﾈ ﾒ JBd ﾞ R/P/色 R 蔵 4 蕩ｧ jA)v ｨФｬ D・ e 7Y&・｢Ｘ
m・・4｢ 1V ﾐЩﾇ U 瑞_ﾜ([(ﾋ囈 H・'O*$ﾄ
ｼ A ・ 辛 ｳ * ｢ ^ e ｲ ｼ A 跏 ・ 五 ｌ 2 ﾞ ・ j 掫 x ・ -* 愰 F
T7 ｲｺ m・*E 碓添
~
G ｧ ﾗ.ﾖｻ=ｺ y-D ｿ銚ﾟ uj 淳 Om ﾍﾃﾇ Jc-ｴ 7・ 煬踴ﾚﾘ W ﾚｯ 54•\.mC ﾅﾞ・ｴ o /
ｧ嶹 渝ﾎ}ﾙ・w 0稘夛
endstream
endobj
107 0 obj<</OCGs 96 0 R/Type/OCMD>>
endobj
108 0 obj<</OPM 1/OP false/op false/Type/ExtGState/SA false/SM 0.02>>
endobj
105 0 obj<</StemV 138/FontName/Arial-BoldMT/FontStretch/Normal/FontWeight
700/Flags 32/Descent -211/FontBBox[-628 -376 2000 1010]/Ascent
905/FontFamily(Arial)/CapHeight 718/XHeight 515/Type/FontDescriptor/ItalicAngle
700/Flags
34/Descent -216/FontBBox[-558 -307 2000 1026]/Ascent 891/FontFamily(Times New
Roman)/CapHeight 656/XHeight -546/Type/FontDescriptor/ItalicAngle 0>>
Word)>>/PageElement<</Subtype/HF>>>>/Name(HeaderFooter)/Type/OCG>>
endobj
97 0 obj<</CropBox[0 0 595.22 842]/Parent 6 0 R/StructParents 0/Contents 109 0
R/Rotate 0/MediaBox[0 0 595.22 842]/Resources<</XObject<</Im0 111 0
R>>/ColorSpace<</CS0 102 0 R/CS1 110 0 R>>/Font<</TT0 98 0 R/TT1 99 0 R/TT2 100 0
R/C2_0 101 0 R>>/ProcSet[/PDF/Text/ImageC/ImageI]/Properties<</MC0 107 0
・囿>
ﾜ淹ｼ ・$2 彭閠 hfa`xd ﾊv'・ 330 ﾜﾙ ｲ〟・ n ﾃ ・c @~ﾝ _
endstream
endobj
117 0 obj<</Length 22/Filter/FlateDecode/W[1 1 1]/Index[9 85]/DecodeParms<</Columns
YT ・ ｷ
T#) l 桟閘ж)Y ﾏ 2 澤ﾆﾑ§ﾟ蔭､ｬｶﾓ$e'%H・痂 2
e-2 ｭ瀰 6
・4 -:ﾘ K
zI ・揺@楷 ﾊ*n%吋は$a ﾓ*tr ｲ d 捜ｔI #・・慈ﾀ ｵ"・=Ｑﾒ
ﾈﾂ漑・J ｯｵﾓ ｵ・2・・ﾞ・ｼ GL>g0
f勿 ｬX
+宦 w・・冩 ﾘ幢 r; x
柎ﾙ・<
%PDF-1.4 %粤ﾏﾓ 94 0 obj <</Linearized 1/L 65077/O 97/E 54121/N 2/T 63150/H [ 796 255]>> endobj
xref 94 25 0000000016 00000 n 0000001220 00000 n 0000001503 00000 n 0000001659 00000 n 0000002012 00000 n 0000002480 00000 n 0000002855 00000 n 0000003010 00000 n 0000003141 00000 n 0000003187 00000 n 0000003430 00000 n 0000003679 00000 n 0000003907 00000 n 0000005207 00000 n 0000005250 00000 n 0000005327 00000 n 0000007743 00000 n 0000007779 00000 n 0000010874 00000 n 0000013544 00000 n 0000013643 00000 n 0000053712 00000 n 0000053949 00000 n 0000001051 00000 n 0000000796 00000 n trailer <</Size 119/Prev 63139/XRefStm 1051/Root 95 0 R/Info 8 0 R/ID[<02B1A93F8C8617FA3E099915C3175A97><1A8CED7231E05B49A1E4261DC26510A5>]>> startxref 0 %%EOF
3/Predictor 12>>/Size 94/Type/XRef>>stream
x ﾚ bbbf`b`` ﾅﾔﾃ ｰ・
endstream
endobj
95 0 obj<</MarkInfo<</LetterspaceFlags 0/Marked true>>/Metadata 7 0
R/PieceInfo<</MarkedPDF<</LastModified(D:20101010184500)>>>>/Pages
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 444]/BaseFont/TimesNewRomanPSMT/FirstChar
32/Encoding/WinAnsiEncoding/Type/Font>>
endobj
99 0 obj<</Subtype/TrueType/FontDescriptor 104 0 R/LastChar 120/Widths[250 0 0 0 0
endobj
102 0 obj[/Indexed 110 0 R 15 113 0 R]
endobj
103 0 obj<</StemV 82/FontName/TimesNewRomanPSMT/FontStretch/Normal/FontWeight
400/Flags 34/Descent -216/FontBBox[-568 -307 2000 1007]/Ascent 891/FontFamily(Times
6
0
R/PageLayout/OneColumn/OCProperties<</OCGs[96 0 R]>>/StructTreeRoot 9 0
R/Type/Catalog/LastModified(D:20101010184500)/PageLabels 4 0 R>>
endobj
96 0 obj<</Usage<</CreatorInfo<</Subtype/Artwork/Creator(Acrobat PDFMaker 7.0 for
0 722 667 0 722 0 556 0 0 333 0 0 0 889 0 0 0 0 0 556 0 722 0 0 0 0 0 0 0 0 0 0 0
0 0 444 500 444 333 0 0 278 0 0 278 778 500 500 500 0 333 389 278 500 0 0 500 0 0
=8% i%!ﾎ )3・%I3
・・- hp､A・g1 ｾ菷・ ,
R ｸ栂 t<ﾓ)h@釖E[燭{ 春|D:U ﾀ{ 1 ｰ u 冕]ﾝ iT]O ｱ・[N)
闡 y=
|娉､
Ms/偐｢G 愠 v
b
ﾂ・ｲ侚・ PV e!9PR$朖ｷ等 D+･ｷ庖｢ｷ・h ・-
*ｵ c|
F ﾕ 3 ﾒ R 翠 4 ｼﾑ
R>>/ExtGState<</GS0 108 0 R>>>>/Type/Page>>
endobj
98 0 obj<</Subtype/TrueType/FontDescriptor 103 0 R/LastChar 148/Widths[250 0 408 0
0 0 0 0 333 333 500 0 250 0 0 0 500 500 0 500 0 500 500 500 500 0 278 0 0 564 0 0
endobj
109 0 obj<</Length 2345/Filter/FlateDecode>>stream
32/Widths[278]/BaseFont/Arial-BoldMT/FirstChar
32/Encoding/WinAnsiEncoding/Type/Font>>
endobj
101
0
obj<</Subtype/Type0/DescendantFonts[116
0
R]/BaseFont/GBIFBL+SimSun/ToUnicode 106 0 R/Encoding/Identity-H/Type/Font>>
0>>
endobj
106 0 obj<</Length 1229/Filter/FlateDecode>>stream
H 欝 蜂 o ・ ・ ・ : ｶ 霖 ﾜ ﾀ - r 閧 ~i ・ I ･ ﾇ p
}
~ ⑤ x< 恤 ｣ ﾑ
ｿ] z S
ห้องสมุดไป่ตู้
V 歙 N サ Cy ﾉﾗ ・~]ﾏﾃ｡)•
6
z・~xz ｲ?・・ｯ由//
:d;ﾆ椚 V;笨 U 輯峽ｷｱ_f
ﾚ prYp ﾒ dI・ｪ m 髑 !zd ﾚ a・、ｮ=ﾆ e・・艤 A%I*$D J・ｴｿ干 ﾆぐ:ソｯ釣-ｬﾄ+郞ｖ椚尊・
筥好ﾍﾂ・ｵ・&%R・個
3 ､ﾑ r 倡档ｱ -茶 ・g・ ｡・鞁 6 ﾓ lH・I;i a
・ ・q 橈@ﾚ 2h
F ｳ a\F 客 i6|・! 6-mf ｬ U ﾑ c ｭ 2E#2・ c
118 0 obj<</Length 162/C 176/Filter/FlateDecode/I 198/L 160/S 91>>stream x ﾚ b```b``y ﾀﾀﾊﾀﾀ ﾀ ﾀ @1V ・
・ ・@団 H 禔・ ﾐ戓 Q ﾖｼ Q・h3 +::@ 逗( 30 ｨ痕`ｴ e ﾜﾀ ﾌ P ﾎ ﾏﾀﾅ p 榱*ﾃ ・
ｧ銹飢•・~ q> ]_・: ~(u ｿ;L?ｯ軅ﾖﾗ:
:( +・ｼ諂 YO ﾏ u8) p4 ﾕ・C=包
蚰 MJ ｽ m ﾏ•ｭ僚｣P9 ｴ・蛾ｾ Sq I ﾓ m-ﾍ d ｧ*I3 ﾉΖ 墲 4・H R%ﾁｦ ｴ｢f e・ｩ H
)キi
ｲ dWPp @+#ｭｬｴ 2 ﾑﾊﾊ・On ｴ XP ｦ,Q 殆ﾒ ｪｰ y ｫ・ｨ D ﾒｨ・ﾐ K zV# ' O:
0 0 0 0 0 0 570 0 0 0 0 0 500 500 500 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 667 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 444 0 444 333 0 556 278 0 0
278 0 556 0 0 0 444 389 333 0 0 0 500]/BaseFont/TimesNewRomanPS-BoldMT/FirstChar
32/Encoding/WinAnsiEncoding/Type/Font>>
endobj
100 0 obj<</Subtype/TrueType/FontDescriptor 105 0 R/LastChar
New Roman)/CapHeight 656/XHeight -546/Type/FontDescriptor/ItalicAngle 0>>
endobj
104
0
obj<</StemV
136/FontName/TimesNewRomanPS-BoldMT/FontStretch/Normal/FontWeight