3L的没说到点子上:
应该是sumproduct或者sum+if数组(下次我将贴出这个教程)
=sumproduct((A1:A100=“条件1”)*(B1:B100=“条件2”),C1:C100)
{=sum(if((A1:A100=“条件1”)*(B1:B100=“条件2”), ...
roych 发表于 2010-1-12 13:21
{=SUM(SUMIF(INDIRECT("sheet"&ROW($13)&"!a:a"),A1,INDIRECT("sheet"&ROW($13)&"!b:b")))}
pureshadow 发表于 2010-1-14 21:44
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |