Forum Discussion
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 ...
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))