Excel formula Help Needed SUMPRODUCT

[Nazmulhasan911]

Hi ,

I need help regarding excel formula. I want to make a excel chart where if there is only numeric number in the cell that can count but if the cell is blank or text that can not count . Help please 

[#2]

@Nazmulhasan911 

Please explain your data and expected result through a sample or actual file.

Thanks,

[#3]

If the cells you want to evaluate are in Column A and you want to count the number of cells that include a number in them, then this formula may return the count you want:
=SUMPRODUCT(—ISNUMBER(FIND(ROW(1:10)-1,
A:A)))

[#4]

@Nazmulhasan911 

I didn't test my earlier formula. Upon testing, such formula sadly returned an incorrect result. Conversely, this formula returns the correct result: 

=SUMPRODUCT(--(MMULT(--ISNUMBER(SEARCH("*"&COLUMN(A1:J1)-1&"*",
A:A)),
ROW(1:10)^0)>0))