Blank Cells in a Row 1

[Scott24x7]

All,
I'm sure I'm missing something obvious, but just not figuring this out. I have a sheet that has many rows, (number is not important, and is 30 columns wide (from B to AI). I want to check at the end of the row (In say, AJ) how many of the cells in the row do not contain a value, or are = to "". ISBLANK() didn't seem to do it, and SUMRPDOCUT seemed like it would need an argument for each column. Is there a "Better way"?


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[xlhelp]

How about =countif(B2:AI2,"") ?

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[GlennUK]

How about:

=COUNTBLANK(B2:AI2)

?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Scott24x7]

Glenn,
Hmmm... you'd think after, I don't know, 15 years with Excel, I'd have encountered that formula before... Having a "Oh my, please tell me it's not that easy" moment.
Thanks very much. Will store that in by "Stupid useful" section of my brain, and hope to retreat quietly into the shadows.
Thanks!

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[GlennUK]

Ha ha Scott,

I know what that's like ... I still have moments like that myself. I'm glad that I've spread some knowledge usefully.



Cheers, Glenn.

Beauty is in the eye of the beerholder.