在BM6输入公式：=SUM(IF($E$5:$BL$5="入",E6:BL6,""))-SUM(IF($E$5:$BL$5="出",E6:BL6,""))按ctrl++shift+enter 3个键
发来我帮你看一下，写清楚具体要做什么。masato@meephone.com
