Computeractive

Make Office Better

LIBREOFFICE CALC & MICROSOFT EXCEL

Count the empty cells in your spreadsheet

There may be times when you need to count the number of empty cells in a spreadsheet. You can do this in LibreOffice Calc and Microsoft Excel using the ‘COUNTBLANK(range)’ function.

You’re reading a preview, subscribe to read more.

More from Computeractive

Computeractive5 min read
Consumeractive
Q Last month I discovered that for the past 14 years Norton has been taking annual payments from me, amounting to over £580. I took out a subscription in 2008, which I stopped using years ago. Norton has refunded me for this year’s renewal, but can I
Computeractive1 min read
The World’s Gone Mad!
This woman’s pendant is a new AI device called ‘Friend’ that listens to what you say and responds in a chat window on your phone. Apparently, it comments unprompted on things that happen in your life, just like real friends used to. Remember them? Wa
Computeractive12 min read
Problems Solved
Q I’ve been using Lotus SmartSuite for many years in various versions of Windows. I think the version currently on my Windows 10 Home PC came from an IBM archive site. The only part I need is Lotus Organizer, which I use to store my address book with

Related Books & Audiobooks