Count blank cells in a row after a specific value

[Murari Rajagopalan]

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

 

[Chihiro]

Since 100.5 is the last data in given row.

Try...
=COLUMNS(C2:S2)-MATCH(100.5,C2:S2,0)

 

[bosco_yip]

In T2, copied down :

=COLUMN(S1)-MATCH(9^9,A2:S2)

Or

=S$1-LOOKUP(9^9,A2:S2,A$1:S$1)

Regards
Bosco

 

[Murari Rajagopalan]

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.

 

[bosco_yip]

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

 

[Chihiro]

Same concept as bosco's
=COUNTBLANK(S2:INDEX(A2:S2,MATCH(100.5,A2:S2,0)))

 

[Murari Rajagopalan]

thank you very much. Appreciate the quick support.