Count only cells where formula returns a number

[Rainmanne]

I've got a table where I need to count a number of cells that are numbers. The numbers are returned by formulas and it might be any number of years as well as text headings.

I tried something like

=SUMPRODUCT((1:1)*ISNUMBER(1:1))

But it does not work.

 

[Rainmanne]

Not really, especially if you have cells that return "". At then end of the day numbers should always be real numbers & not text, otherwise it is likely to lead to all sorts of problems.

You are right. It's just I use them in INDEX MATCH with another worksheet generated buy an external programme, where dates are text. So it was easier for me to use them as they are and convert into numbers in a few formulas where it was necessary.

 

[Rainmanne]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		J	G		C	5	K		E	6		H	D	B
2
3	Count of Numbers:	2
4
Sheet2

Cell Formulas
Range	Formula
B3	B3	=SUMPRODUCT(ISNUMBER(--B1:N1)*(LEN(B1:N1)>0))

Thanks a lot! It works!