Dear Experts,

                     In attached worksheet, names COUNTA_ISBLANK, in Column “I”, I need to put the number of cells from “B to H” having some data as below, so for the Row num=2, from B to H we have only 2 cells C2 and D2 having text so in Result it should be 2, I tried using COUNTA, ISBLANK , but something’s not working for me.. similarly for Row 3, B3,C3,D3 and F3 have some text so in Result should be 4 and so on.

Thanks in Advance,

Br,

Anupam

​Dear Experts,                     In attached worksheet, names COUNTA_ISBLANK, in Column “I”, I need to put the number of cells from “B to H” having some data as below, so for the Row num=2, from B to H we have only 2 cells C2 and D2 having text so in Result it should be 2, I tried using COUNTA, ISBLANK , but something’s not working for me.. similarly for Row 3, B3,C3,D3 and F3 have some text so in Result should be 4 and so on.Thanks in Advance,Br,Anupam   Read More

​