Forum Discussion
Gabriel Hernandez
Sep 11, 2018Copper Contributor
Countif function help
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
- Detlef_LewinSilver Contributor
Hello Gabriel
=SUMPRODUCT(--(C6:C28>=B6:B28))