=COUNTA function not working properly

[Stona]

Hi i have this formula

Please Login or Register  to view this content.

i use a userform for when i click on pass, the word pass is displayed in another cell

what i want to happen is when the cells are blank a 0 (zero) must be displayed

[Richard Buttrey]

The file you uploaded does return zero when C1:C7 are blank since it's counting the number of "Pass" words which is zero.

Please clarify.

[Stona]

i want the formula to automaticaaly count the blank cells and put the total in C10

[TMS]

I think you'd use COUNTBLANK for that.

Your file indicates you might want something like this:

Please Login or Register  to view this content.

[Stona]

range is from D8 to D14.

function should count all the words with the name "Pass" . if three cells has the word it must return the value of 3 in cell D16.

if all the cells in the range has zero value empty cells, it must count it and return 6 in cell D16.

the range will always only have the word Pass or blank cells in it

[TMS]

Not sure why you've changed the range but here's some examples

Please Login or Register  to view this content.

Non-blank entry present

Please Login or Register  to view this content.

Count blanks

Please Login or Register  to view this content.

Count zero or blanks

Please Login or Register  to view this content.

Count non-blanks

Please Login or Register  to view this content.

Count "pass"

Please Login or Register  to view this content.

Count non "pass"