excel 求某值有几个

Question

RT
A1:A5
C1:C5
D1;D5
中值=“男”的个数

Answer 1

在一空闲单元格内输入：
=COUNTIF(A1:D5,"男")
即可

如果只是隔行统计，也可：
=COUNTIF(A1:A5,"男")+COUNTIF(C1:C5,"男")+COUNTIF(D1:D5,"男")

Answer 2

=SUM(COUNTIF(A1:A5,"男"),COUNTIF(C1:C5,"男"),COUNTIF(D1:D5,"男"))

Answer 3

=COUNTIF(A1:A5,"男")+COUNTIF(C1:d5,"男")本回答被提问者采纳

Answer 4

A6内输入
=COUNTIF(A1:A5,"男")
右拉填充