COUNTIF in array formula isn't allowed, while COUNT is. Why ?

[szakharov7723]

Can you please help me find a way around

Can't figure out why this one working:

{=COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1))}

Which evaluates in something like

COUNT({2,4,6,2})

. And it results in 4

Now I want to count only 2. So I use:

{=COUNTIF((ISNUMBER(SEARCH(List,E522))*(ROW(List)-1)),2)}

But this one doesn't work ?? Not even letting me execute this formula ?

 

[joshman108]

I think it's failing because countif does not work on an array, only ranges.
This should work

{=SUM(IF({your_array}=2,1,0))}

It seems to work without being an array formula too but I'm not sure how excel is set up in that regard across versions

 

[joshman108]

Concretely, youR formula should be:

{=SUM(IF(COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1)))=2,1,0))}

 

[szakharov7723]

Thank you, it worked !