Super simple countifs function gives error 502

gives error 502
but these work:

I’m sure it is super simple but I just can’t figure it out. The target cells have just nothing or 0 in them. I tried pasting the formula to another sheet and it just fails. Yet this works:

I don’t see anything different at all between the two?!

Yep. Super-simple. Read the giant red highlighted box on the first page of the most obvious documentation for the function:

1 Like

I always say that if you want something to be invisible to me, just highlight it. I must not be the only one.:confused: