Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Excel 2007 counting blank cells

financial excel course london - Excel 2007 counting blank cells

ResolvedVersion Standard

Tue 15 Jan 2008, 16:22 Delegate Caroline said...

Caroline has attended:
Excel Intermediate course

Excel 2007 counting blank cells

How to count blank cells?

Wed 16 Jan 2008, 13:24 Trainer Rajeev said...

RE: excel 2007 counting blank cells

Dear Caroline

Thank you for attending the Excel Intermediate Course.

Knowing which cells are empty can be very useful task as it might have been done as a mistake by the user. To count the No. of cells that are blank you can use a function called COUNTBLANK.

It is quite straightforward.

Step 1: Click on the cell where you want the result.
Step 2: Type =COUNTBLANK(Range)

[b]NB:

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

financial excel course london - Excel 2007 counting blank cells

Excel 2007 counting blank cells

RE: excel 2007 counting blank cells

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error