A B C A 1班 95 B 2班 50 C 3班 80 ’=SUMPRODUCT(($B$1:$B$3,"1班")*($C$1:$C$3,">59请帮助我修改下错误的公式

来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/26 19:42:21
ABCA1班95B2班50C3班80’=SUMPRODUCT(($B$1:$B$3,"1班")*($C$1:$C$3,">59请帮助我修改下错误的公式ABCA1班9

A B C A 1班 95 B 2班 50 C 3班 80 ’=SUMPRODUCT(($B$1:$B$3,"1班")*($C$1:$C$3,">59请帮助我修改下错误的公式
A B C A 1班 95 B 2班 50 C 3班 80 ’=SUMPRODUCT(($B$1:$B$3,"1班")*($C$1:$C$3,">59

请帮助我修改下错误的公式

A B C A 1班 95 B 2班 50 C 3班 80 ’=SUMPRODUCT(($B$1:$B$3,"1班")*($C$1:$C$3,">59请帮助我修改下错误的公式
=SUMPRODUCT(($B$1:$B$3="1班")*($C$1:$C$3>59.6))