ExcelBanter - Why the minus result

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Why the minus result (https://www.excelbanter.com/excel-worksheet-functions/251102-why-minus-result.html)

Gotroots

Why the minus result

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

Why the minus result

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
--
Max
Singapore
---
"gotroots" wrote:
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

RonaldoOneNil

Why the minus result

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

"gotroots" wrote:

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

All times are GMT +1. The time now is 04:39 AM.