SUMIFS(indirect($f$3&"!$N:$N"),indirect($f$3&"!$A:$A"),$A6,indirect($f$3&"!$J:$J"),"期初余额")+SUMIFS(indirect($f$3&"!$L:$L"),indirect($f$3&"!$A:$A"),$A6,indirect($f$3&"!$K:$K"),"<"&TEXT($B$3&"-"&$D$3,"YYYY/MM"))-SUMIFS(indirect($f$3&"!$M:$M"),indirect($f$3&"!$A:$A"),$A6,indirect($f$3&"!$K:$K"),"<"&TEXT($B$3&"-"&$D$3,"YYYY/MM")) 原来如此!!! |