【会计四期】第六讲上交作业贴（23-44号）

hx910

[Power=1]<p>[Power=1]</p><p>02028&nbsp;&nbsp; hx910&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p><p>1&nbsp;&nbsp;&nbsp; 数组=ROW(B18)-ROW(B5)+1-SUM(--ISNONTEXT(B5:B18))</p><p>&nbsp;&nbsp; 数组=SUM(IF(ISNONTEXT(B5:B18),0,C5:C18))/(ROW(B18)-ROW(B5)+1-SUM(--ISNONTEXT(B5:B18)))&nbsp; <font color="#f70909">想复杂了！</font></p><p>2&nbsp; （1）数组=SUM(IF(DATEDIF($D$26:$D$52,TODAY(),"Y")&lt;5,0,IF(DATEDIF($D$26:$D$52,TODAY(),"Y")&gt;=10,0,1)))</p><p>（2）=OFFSET(C25,MATCH(MAX(D26:D52),D26:D52,0),,,)</p><p>（3）</p><p>（4）=DATEDIF(VLOOKUP("欧阳",C26:D52,2,FALSE),TODAY(),"Y")</p><p>（5）=IF(MONTH(D26)&gt;MONTH(TODAY()),"今年未到",IF(DAY(D26)&gt;DAY(TODAY()),"今年未到",(IF(DATEDIF(D26,TODAY(),"Y")&lt;1,0,IF(DATEDIF(D26,TODAY(),"Y")&lt;5,3,6)))))&nbsp; <font color="#e61a1a">不对！</font></p><p>（6）=COUNTIF(E26:E52,"&lt;&gt;今年未到")&nbsp; <font color="#ff0000">不应用辅助列</font></p><p><font color="#ff0000">继续努力！</font></p><p><font color="#ff0000">——dgxsdr</font></p>[/Power][/Power]

[此贴子已经被dgxsdr于2010-6-28 15:16:06编辑过]

真永远

<p>[Power=1]一、<br/>1、=SUM(--ISTEXT(B5:B18))&nbsp; &nbsp;<br/>2、=SUM(ISTEXT(B5:B18)*C5:C18)/8&nbsp; <font color="#f70909">不能直接用上题结果</font><br/>二、<br/>1、{=SUM((DATEDIF(D26:D52,TODAY(),"y")&gt;=5)*(DATEDIF(D26:D52,TODAY(),"y")&lt;=10))}<br/>2、=INDEX(C26:C52,MATCH(MAX(D26:D52),D26:D52,))<br/>3、=TEXT(DATEDIF(INDEX(D26:D52,MATCH("欧阳",C26:C52,)),TODAY(),"y"),0)&amp;"年"&nbsp; <font color="#e61a1a">第4小题的</font></p><p><font color="#e61a1a">继续努力！</font></p><p><font color="#e61a1a">——dgxsdr<br/></font><br/>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-28 15:23:36编辑过]

wen191244510

<p>关了？</p>

wen191244510

[Power=1]<p>一、=SUM(ISTEXT(B5:B18)*1)数组</p><p>=SUM(ISTEXT(B5:B19)*1*C5:C19)/SUM(ISTEXT(B5:B18)*1)数组</p><p>二、1、=SUM((DATEDIF(D26:D52,TODAY(),"y")&lt;10)*1)-SUM((DATEDIF(D26:D52,TODAY(),"y")&lt;5)*1)数组</p><p>2、=OFFSET(C25,MATCH(MAX(D26:D52),D26:D52,0),0)</p><p>3、=MODE(YEAR(D26:D52))</p><p>4、=DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"Y")&amp;"年"&amp;DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"YM")&amp;"月又"&amp;DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"Md")&amp;"天"</p><p>6、=SUMPRODUCT((DATEDIF(D26:D52,TODAY(),"yd")&lt;TODAY()-DATE(YEAR(TODAY()),1,1))*(DATEDIF(D26:D52,TODAY(),"y")&gt;=1))</p><p><font color="#ff0000">第5题未做，其他OK!</font></p><p><font color="#ff0000">——dgxsdr</font></p>[/Power]

[此贴子已经被dgxsdr于2010-6-28 15:30:56编辑过]

含

[Power=1]<p>2组26号交作业&nbsp; 含</p><p></p><p></p><p></p><p>1、=SUM(ISTEXT(B5:B18)*1)&nbsp; 三键结束（shift ctrl&nbsp; enter)&nbsp;&nbsp;&nbsp; =SUM(ISTEXT(B5:B19)*1*C5:C19)/SUM(ISTEXT(B5:B18)*1)三键结束（shift ctrl&nbsp; enter)&nbsp;</p><p>其他不会</p><p><font color="#f70909">要努力了。。。</font></p><p><font color="#f70909">——dgxsdr</font></p>[/Power]

[此贴子已经被dgxsdr于2010-7-1 17:52:55编辑过]

呐记忆

[Power=1] zPmvVdeU.rar (5.78 KB, 下载次数: 1)

2010-6-28 15:54 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（23-44号） <br/>[/Power]

沙漠王子1

[Power=2]<p>交的是检查：</p><p>&nbsp;</p><p>[em03]</p><p>本人没有交作业，因为不太会！可能是工作中日期函数运用的较少，不能够灵活运用，所以虽然前后听了两遍录像，但作业还是相当的吃力！</p><p>在此向君老师致于深深的谦意——对不起了！</p>[/Power]