Countif function help

Copper Contributor

Hi! I'm trying to figure out how many of the cells in the right column are greater than or equal to their corresponding neighbor on the left column. I am currently trying =COUNTIF(C6:C28, ">=" & B6:B28) but it isn't working.

 

Any tips?

1 Reply

Hello Gabriel

 

=SUMPRODUCT(--(C6:C28>=B6:B28))