Count non blanks against formula

[Caly]

I have a formula in a cell that will return either data or leave the cell blank. I want to do a count that will show the number of lines that has data but when I do this, the formula includes the cells that are blank. How can I exclude those? I think it is because the formula doing the count thinks there is data since it is a formula and it is not hard coded.
Formula in the cell is
=if(A1=“Yes”,”Yes”,””)

the formula to do the count is below but it includes the blank cells
=countif($A$1:$A$3,”<>”)

 

[Eric W]

A few options:

Book1 (version 1).xlsb
	A	B	C	D	E
1	Yes	Yes	2	2	2
2
3	Yes	Yes
Sheet32

Cell Formulas
Range	Formula
C1	C1	=COUNTIF(B1:B3,"Yes")
D1	D1	=SUMPRODUCT(--(B1:B3<>""))
E1	E1	=COUNTA(B1:B3)-COUNTBLANK(B1:B3)
B1:B3	B1	=IF(A1="Yes","Yes","")

 

[Caly]

This worked perfectly. Thank you so much

 

[Marcelo Branco]

Another

=COUNTIF(B1:B3,"><")

M.

 

[Phuoc]

One way:

=COUNTIF(B1:B3,"?*")