大于等于条件判断

啊棒棒糖

问符合条件的加起来共多少岁，又怎么计算？

loirol

=countif(b:b,">="&d2)

zhangcheng6688

借楼学习一下数组
Sub test()
arr = [d1].CurrentRegion
brr = [a1].CurrentRegion
For i = 2 To UBound(arr)
   For j = 2 To UBound(brr)
      If brr(j, 2) >= arr(i, 1) Then
         arr(i, 2) = arr(i, 2) + 1
      End If
   Next
Next
[d1].CurrentRegion = arr
End Sub

wp231957

=SUMIF(F4:F16,">"&I4)
=COUNTIF(F4:F16,">"&I4)

杨杨1991315

方法一：=SUM(--($B$2:$B$12>=D2))
方法二：=COUNT(0/($B$2:$B$12>=D2))
两种方法，输入完公式，需要按CTRL+SHIFT+回车，结束

quqiyuan

1. =COUNTIF(B:B,">="&D2)

复制代码

沈默00

=COUNTIF(B2:B12,">="&D2)
=SUM(IF(B2:B12>=D2,1,))
=SUM(N(B2:B12>=D2))

朝露孤烟

符合条件的加起来共这么多岁，=sumif(B:B,">="&D2,B:B).  这么多个，=countif(B:B,">="&D2.

mykitami

=COUNTIF(B:B,">="&D2)