本帖最后由 砂海 于 2015-5-7 12:43 编辑
占楼
e2:G2 , 三键,下拉
=CHOOSE({1,2,3},TEXT(DATE(2012,11+ROW(),1),"YYYY年M月"),SUM(F1,G2),SUM((12*(B$2:B$535>41639)+MONTH(B$2:B$535)=ROW()-1)*C$2:C$535))
e2:G2 , 三键,下拉
=CHOOSE({1,2,3},TEXT(DATE(2012,11+ROW(),1),"YYYY年M月"),SUMIF(B$2:B$535,"<"&DATE(2012,12+ROW(),1),C$2:C$535),F2-SUM(F1))
e2:G2 , 三键,下拉
=CHOOSE({1,2,3},TEXT(DATE(2012,11+ROW(),1),"YYYY年M月"),SUMIF(B$2:B535,"<"&DATE(2012,12+ROW(),1),C$2:C535),F2-SUM(F1))
e2:G2 , 三键,下拉
=CHOOSE({1,2,3},TEXT(41213+31*ROW(),"YYYY年M月"),SUMIF(B$2:B535,"<"&DATE(2012,12+ROW(),1),C$2:C535),F2-SUM(F1)) |