函数入门班练习题:双条件求和!

blacktulip20

不会 学学

sallin

<p>感觉自己越学越无知了</p>

[此贴子已经被作者于2008-6-4 12:13:36编辑过]

blacktulip20

<p>=SUM((A2:A201=H2)*(D1:F1=I2)*D2:F201)</p><p>这个我用了出错哟 见下图</p><p><table cellspacing="0" cellpadding="0" width="288" border="0" xstr="" style="WIDTH: 216pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl65" width="216" colspan="3" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 162pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体" size="2">SUMPRODUCT((A2:A201=H2)*(D1:F1=I2)*D2:F201)</font></td><td class="xl66" width="72" xnum="" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">4087</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl65" colspan="3" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体" size="2">SUM((A2:A201=H2)*(D1:F1=I2)*D2:F201)</font></td><td class="xl66" xerr="#VALUE!" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">#VALUE!</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl65" colspan="2" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体" size="2">DSUM(A:F,I2,H1:H2)</font></td><td class="xl66" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td><td class="xl66" xnum="" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">4087</font></td></tr></tbody></table></p>

sallin

<p>为什么我两个都用出错呢 谁能来解释下公式意思 </p><p></p>

凉白开

看看，学学

美丽新世界

<p>不知道对不对啊</p><p>

游客，如果您要查看本帖隐藏内容请回复

</p>

honghe

<p>学习一下</p>

迷途

游客，如果您要查看本帖隐藏内容请回复

bear87476870

学学

liuyingzi28

游客，如果您要查看本帖隐藏内容请回复