Super simple countifs function gives error 502

[danix]

=COUNTIFS(B133:B165;">=0";H134:H139;">=0")
gives error 502
but these work:
=COUNTIFS(H134:H139;">=0")
=COUNTIFS(B133:B165;">=0")

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:
=COUNTIFS(C5:C8;">=0";D5:D8;">=0")

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

[joshua4]

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

https://help.libreoffice.org/6.1/en-US/text/scalc/01/func_countifs.html?DbPAR=CALC

[joshua4]

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