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?
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?
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?
% 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")