Forum Discussion

Copper Contributor

Jul 21, 2019

Excel formula Help Needed SUMPRODUCT

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 ...

excel

tauqeeracma

Iron Contributor

Jul 21, 2019

Nazmulhasan911

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

Thanks,

Twifoo
Silver Contributor
Jul 21, 2019
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)))