Count cells that are numbers and greater than a value

=COUNTIFS("B1:B7,">20")
{=B2:G2>5} = {TRUE , TRUE , FALSE , FALSE , TRUE , TRUE}


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top