Microsoft Excel - Count empty cells in one column based on information in another

I need to count blank cells in Column E (Chalk)  when information is present in Column A (Unit). 
**Example:  Based on Column A, there are 42 rows that still require to be chalked (filled in).  This number would decrease as Column E is filled in.

Thank you!

Chalked: 005  Unchalked:  ???

UNIT	UTC	ULN	LNR	CHALK
AMXS	HMREN	TH8D14	004	004
APS	UFBBS	TU8D14	001
AS	3MGB4	T38D14	011	001A
FSS	RFSRB	TR7D4	004	009
AMXS	HMREN	TH8D14	007	004
AES	FFQCM	TF8D4	006
AMXS	HMHED	TH7D3	001	012

Hello Seab,

Why don't you just count the instances in column UNIT and subtract the instances in column CHALK (which you seem to be doing already)?

Harry

You can use =COUNTIFS(E1:E??,"",A1:A??,">=0") just fill in the ?? with you range and place this in you count cell, I looks for blanks in E:E and counts those where A:A has data


HTH

Don