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

Asked By Seab Herron on 18-Sep-12 12:24 PM
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
Harry Boughen replied to Seab Herron on 18-Sep-12 05:27 PM
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
Donald Ross replied to Seab Herron on 18-Sep-12 10:55 PM
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