How to count non blank cells excluding those with formulas that resolve to ""?

[excelos]

Hello!

I have a formula that returns some numbers or "".

How do I count the non blank values which may have a formula resolving to "" or may not have a formula at all?

Thanks!

 

[Marcelo Branco]

Try
=SUMPRODUCT(--(A2:A10<>""))
adjust the range

M.

 

[Peter_SSs]

I have a formula that returns some numbers or ""

Perhaps I have not understood correctly, but if you are counting numbers then you should be able to just use COUNT()

21 10 12.xlsm
	A	B	C
1	3	3	3
2
3	33	33
4		55
Count

Cell Formulas
Range	Formula
C1	C1	=COUNT(B1:B4)
B1:B3	B1	=IF(A1="","",A1)