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