Ask Your Question
0

How to count blank cells - formerly: Check if within a range of cells (a row) there is at least one blank cell [closed]

asked 2013-02-07 17:39:44 +0100

miromarchi gravatar image

updated 2015-10-21 15:37:58 +0100

Alex Kemp gravatar image

Hi there, I'm trying to find a formula to check if within each row there is at least one blank cell. Im using ISBLANK and OR.

If I do =OR(ISBLANK(A2),ISBLANK(B2),ISBLANK(C2)...) and it works but since my spreadsheet get till column FF, it is a very long formula and I would like to shorten it using ranges capabilities of libreoffice.

I've tried =OR(ISBLANK(A2):ISBLANK(FF2) but got an error E:502 I've tried =ISBLANK(A2:FF2) but got always FALSE

Anyone can help? Thanks so much miro

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 15:38:07.181316

1 Answer

Sort by » oldest newest most voted
1

answered 2013-02-07 23:35:03 +0100

m.a.riosv gravatar image

I think the next formula can work.

=SUMPRODUCT(ISBLANK(A2:FF2))

edit flag offensive delete link more

Comments

hey mariosv, your're great, this is even better than what i was thinking. Your way I get the sum of blank cells in a row, which is exactly what I need. This way I know who (row) has answered to most questions (columns) of the questionaire, and who answered to few. I have the numbers! Love it! thanks

miromarchi gravatar imagemiromarchi ( 2013-02-10 13:41:31 +0100 )edit

In order to better fit this answer with future questions I should append another title, which would be "How To Count Blank Cells".

miromarchi gravatar imagemiromarchi ( 2013-02-11 15:25:09 +0100 )edit

=COUNTBLANK(Range) is working as well, but only with a contiguous range I believe. For my purposes is working well. =countblank is also the same in excel, for who is coming from there.

miromarchi gravatar imagemiromarchi ( 2013-02-11 15:35:20 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-02-07 17:39:44 +0100

Seen: 10,603 times

Last updated: Feb 11 '13