Re: [libreoffice-users] CALC - How to count blank cells?

[Simon Cropper <simoncropper@fossworkflowguides.com>]

On 04/07/12 13:16, dave wagner wrote:
> I have a small range of cells (less than 100) in which I need to count the
> cells that are blank.
> What is the best way to do this?
>
> I was trying something like "=COUNTIF(C11:C103,(CELL("Type",b)))".But that
> just did not work.
>
> Thanks to all who helps me with this simple problem.

try =COUNTBLANK(range)

--
Cheers Simon

   Simon Cropper - Open Content Creator

   Free and Open Source Software Workflow Guides
   ------------------------------------------------------------
   Introduction               http://www.fossworkflowguides.com
   GIS Packages           http://www.fossworkflowguides.com/gis
   bash / Python    http://www.fossworkflowguides.com/scripting



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted