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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 22, 2020

johanchristiaan Pulled your Dutch formula through a translator to English and inserted it into a clean sheet, entering "a" in column P (far enough down to test your formula) and "a" in L62. I count 71 occurrences, as expected from the ranges included in the formula. What are you trying to count? Are you sure that whatever is entered in the 4th range actually contains an exact match with what is in L62? 

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?