Counting Blanks with Conditions

[Ken]

I have two columns that change in length (dynamically). What I need is to
count the blanks in Colunm B but the column length changes every day. Is
there a way to count only the blanks within the data and exclude normal cell
blanks? If an end of row reference is needed maybe I can use column A as a
guide because column A will always show a value of HP.

A
MANAGER_ORG_GROUP
HP
HP
HP
HP
HP
HP

B
REQ_COMPLETION_DATE
4/2/2008 9:00:00 PM
4/7/2008 9:00:00 PM
3/27/2009 12:23:00 AM

4/7/2008 9:00:00 PM
5/10/2008 11:00:00 PM

 

[Gary''s Student]

Much easier to count the non-blanks and subtract this from the max possible.

 

[Ken]

Not quite sure I follow... can you give me a formula example?

Ken

 

[Gary''s Student]

With A1 thru B15:

asdc 2
asdc 2
asdc 2
asdc 2
asdc 2
asdc 2
asdc
asdc
asdc
asdc
asdc 3
asdc 3
asdc 3
asdc
asdc

in another cell enter:
=COUNTA(A:A)-COUNTA(B:B)
which will display 6
the number of blanks in the region of interest.

 

[Ken]

Thanks ... that works. Finally I need to add some exclusion. Can I do the
following or will I need to use Someproduct?

=COUNTA(('DATA (RAW)'!V:V)-COUNTA('DATA (RAW)'!BH:BH)
*('DATA (RAW)'!N2:N5000<>"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<>"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<>"ASIA")
*('DATA (RAW)'!AQ2:AQ5000<>"CALA")
*('DATA (RAW)'!AQ2:AQ5000<>"NA"))