cont.se does not work in Excel

3

I have a column in Excel with 38 rows. Inside them are two words: Yellow and White , I want to count how many times these words have been entered. I used the following formula:

=cont.se(A1:A38;"Branca")

But it did not work, what's wrong?

    
asked by anonymous 27.01.2015 / 02:53

1 answer

1
___ erkimt ___ cont.se does not work in Excel ______ qstntxt ___

I have a column in Excel with 38 rows. Inside them are two words: Yellow and White , I want to count how many times these words have been entered. I used the following formula:

=COUNTIF(A1:A38;"Branca")

But it did not work, what's wrong?

    
_________azszpr48372

% error #NAME indicates that Excel failed to identify certain part of the formula. Instead of CONT.SE use COUNTIF if you are using the English version

=COUNTIF(A1:A38;"Branca")
    
___
27.01.2015 / 03:46