• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count blank cells in a row after a specific value

Hello team,
can you please help to count the blank cells after 100.5 in a row ? i have attached the sample excel file and the expected result in result column. Please help
Regards,
Murari Rajagopalan
 

Attachments

Thanks Bosco and Chihiro. For some reason, this is expecting all cells to be blank after 100.5 as a last value. If I enter a cell with some value, then the count is not same.
 

Attachments

bosco_yip

Excel Ninja
Sorry, misread the question, in T2 formula please fixed by :

=COUNTBLANK(INDEX(B2:S2,MATCH(100.5,B2:S2,0)):S2)

or,

=COUNTIF(INDEX(B2:S2,MATCH(100.5,B2:S2,0)):S2,"=")

Regards
Bosco
 
Last edited:
Top