Forum Discussion

Nazmulhasan911's avatar
Nazmulhasan911
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 please 

excel

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jul 22, 2019

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

    • Twifoo's avatar
      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)))

Resources