本帖最后由 CheryBTL 于 2013-1-24 12:01 编辑
如果行数不定:- =SUM(SUMIF(INDIRECT({"事业","行政","附加","南园","党建"}&"!L:L"),$A2,OFFSET(INDIRECT({"事业","行政","附加","南园","党建"}&"!L1"),,ROW($1:$8)))*(T(OFFSET(INDIRECT({"事业","行政","附加","南园","党建"}&"!L1"),,ROW($1:$8)))=B$1))
复制代码 若行数固定都在L2:L13的话:- =SUM(N(OFFSET(INDIRECT({"事业";"行政";"附加";"南园";"党建"}&"!L"&ROW()),,COLUMN($A:$H)))*(T(OFFSET(INDIRECT({"事业";"行政";"附加";"南园";"党建"}&"!L1"),,COLUMN($A:$H)))=B$1))
复制代码 换成ROW再减几个字符吧:- =SUM(N(OFFSET(INDIRECT({"事业","行政","附加","南园","党建"}&"!L"&ROW()),,ROW($1:$8)))*(T(OFFSET(INDIRECT({"事业","行政","附加","南园","党建"}&"!L1"),,ROW($1:$8)))=B$1))
复制代码 |