Why the minus result

  • Thread starter Thread starter gotroots
  • Start date Start date
G

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
 
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
 
Back
Top