B2 複製往右及下貼
=SUMPRODUCT(DSUM(INDIRECT(ROW($1:$9)&"!A1:D100"),B$1,$A$1:$A2))-SUM(B$1:B1)
B10 公式
{=SUM(COUNTIF(INDIRECT(ROW(1:9)&"!B2:B6"),"<>"))}
B11 公式
{=SUM(SUMIF(INDIRECT(ROW(1:9)&"!A:A"),"合计",INDIRECT(ROW(1:9)&"!C1")))}
B12 公式
{=SUM(SUMIF(INDIRECT(ROW(1:9)&"!A:A"),"合计",INDIRECT(ROW(1:9)&"!D1")))}
[此贴子已经被作者于2010-4-17 11:49:14编辑过] |