Jul 21 2019 05:45 AM
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
Jul 21 2019 06:01 AM
Please explain your data and expected result through a sample or actual file.
Thanks,
Jul 21 2019 06:47 AM - edited Jul 21 2019 07:02 AM
Jul 22 2019 03:19 AM
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))