counting empty cells in a column.

[Charles W Davis]

Office Excel 2007

I have a file with two sheets Addresses and Summary.
In a cell on the Summary sheet, I want to count the number of blank cells in
Column B on the Addresses sheet that contains a Heading row.


I can easily count the number of occurences of the word Westridge in Column
E with this:
=COUNTIF(Addresses!E2:E7061,"Westridge")

=COUNTIF(Addresses!B2:B7061," ")

I can't figure how to count the blank cells.

Thanks.

 

[T. Valko]

Do you want to count how many times column B has a blank/empty cell and
column E of the same row has Westridge?

=SUMPRODUCT(--(Addresses!B2:B7061=""),--(Addresses!E2:E7061="Westridge"))

If you just want to count blank/empty cells:

=COUNTBLANK(Addresses!B2:B7061)

Biff

 

[Trevor Shuttleworth]

=COUNTBLANK((Addresses!B2:B7061)

Regards

Trevor

 

[Harlan Grove]

I can't figure how to count the blank cells.

Excel uses two different definitions of blank: ISBLANK(x) = TRUE and
T(x)="". The former means no cell contents whatsoever. The latter means the
cell evaluates as text to the zero length string "". For the former, use

=-SUMPRODUCT(-ISBLANK(range))

for the latter, use

=COUNTIF(range,"") or =COUNTBLANK(range)

 

[Charles W Davis]

Thanks Biff,

Your first answer provided an answer to a question that I hadn't thought of,
but it was great.

Chuck

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks Biff,

Your first answer provided an answer to a question that I hadn't thought
of, but it was great.

Chuck