excel2007还原第1页

财务

Excel2007财务表格

阅读(4)评论()

F3单元:=IF(COUNTIF(B3:E3,">0"),SUMIF(B3:E3,">0"),"")G3单元:=IF(COUNTIF(B3:E3,"<0"),SUMIF(B3:E3,"<0"),"")H3单元:=IF(COUNT(B3:E3),SUM(H2)+SUM(F3:G3),"")下拉三个公式