CODEWITHSUNDEEP
excel
sam
sam

Reputation: 10094

check if any cells in a range are blank

Ive got a range of cells C1:R10 each with a dropdown with 5 selections including 1 blank value.

I want to add another column in S that will check cells C:R on each row, to see if any cells are blank.

Ive tried using an ISBLANK but this dosnt seem to work, what else could be used here ?

Upvotes: 0

Views: 10178

Answers (1)

Greg Viers
Greg Viers

Reputation: 3523

Try using countblank. Note that it will consider cells that appear blank but are not (such as ones that contain only spaces) as not blank.

=countblank(C1:R10)

Upvotes: 4

Related Questions