Forum Discussion

johanchristiaan's avatar
johanchristiaan
Copper Contributor
Apr 21, 2020

Need help with a formula (countif)

Hi   I using the follow formula: =AANTAL.ALS(P60:P65; L62) I think =AANTAL.ALS is in English =countif I want the add more rows in the same sheet with only 1 goal (B4)   I been bust to work this ...
Excel on Mac
Formulas and Functions
johanchristiaan's avatar
johanchristiaan
Copper Contributor
Apr 22, 2020

Riny_van_Eekelen 

 

Basically the formula needs to look at P60:P65, P128:P53, P162:171 and the last one P198:P226

For something that's is L62.

 

if I set up the formula for only 2 areas P60:P65, P128:P53 and P162:171 it will work. But if I add the P198:P226 the formula will not work any more. I will have only the formula in the cel and not the out coming. 

 

Can it be that the formula is to long?

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 22, 2020

johanchristiaan Have a look at the attached workbook. I created it in an English version, but it will translate to Dutch when you open it. The formula (in A1) works as intended. You didn't answer WHAT you are trying to count. Texts, numbers?