一、E1中输入公式:
=IF(SUM(MOD($A1:$C1,2))=COLUMN()-5,SUM(MOD($A1:$C1,2)),"")
按Ctrl+Shift+回车结束,
向右拉到H1,再一起往下拉.
二、E1中输入:
=IF(SUM(N($A1:$C1>4))=COLUMN()-5,SUM(N($A1:$C1>4)),"")
按Ctrl+Shift+回车结束,
向右拉到H1,再一起往下拉.
一、E1中输入公式:
=IF(SUM(MOD($A1:$C1,2))=COLUMN()-5,SUM(MOD($A1:$C1,2)),"")
按Ctrl+Shift+回车结束,
向右拉到H1,再一起往下拉.
二、E1中输入:
=IF(SUM(N($A1:$C1>4))=COLUMN()-5,SUM(N($A1:$C1>4)),"")
按Ctrl+Shift+回车结束,
向右拉到H1,再一起往下拉.