# Count blank cells in a row after a specific value

#### Murari Rajagopalan

##### Member
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

• 8.9 KB Views: 6

#### Chihiro

##### Excel Ninja
Since 100.5 is the last data in given row.

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

#### bosco_yip

##### Excel Ninja
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

##### Member
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

• 9.3 KB Views: 7

#### 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:

#### Chihiro

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

#### Murari Rajagopalan

##### Member
thank you very much. Appreciate the quick support.