Why the minus result

[gotroots]

Hi

Here are two similar formulas and a typical result:

="flex"&" "&COUNTA(A11:A7799)-COUNTIF(A11:A7799,"")

result: flex 612

="process"&" "&COUNTA('Names'!O2:O1000)-COUNTIF('Names'!O2:O1000,"")

result: process -276


My question is why the minus result for the latter formula when it should
have been; process 276

 

[Max]

One guess at your intents
Maybe try this alternative:
="process "&SUMPRODUCT(--(Names!O2:O1000<>""))
Likewise for the other one for "flex"
Any good? hit the YES below

 

[RonaldoOneNil]

Because there are more empty cells in O2:O1000 than filled in cells ??