excel中countifs函数如何设置大于等于某个单元格的值

Question

=COUNTIFS($C$2:$C$410,R5,$D$2:$D$410,">=82")，比如这里的>=82，我想让这个地方改为>=某一个单元格的值。设置为=COUNTIFS($C$2:$C$410,R5,$D$2:$D$410,">=R2")，但是这样得不出结果。

Answer 1

=COUNTIFS($C$2:$C$410,R5,$D$2:$D$410,">='"&r2)