excel如何将满足条件的A列所对应的B列求和

=SUMIF(A67:A81,"<5",B67:B81) =SUMIFS(B67:B81,A67:A81,">=5",A67:A81,"<=10") =SUMIF(A67:A81,">10",B67:B81) 依次输入这三个公式。 条件那里只写条件，不需要写引用区域的。