How do I count the number of blank cells

[AmyC83]

Hi

This query may already have been asked, but I cannot make sense of wher
to find the answer so I hope someone might be able to help.

So I manage faults on our company CCTV cameras - we have 500 of the
over a large site.

A simplified version of my spreadsheet

A B C D E
Date Location Fault Resolved
Visit
01/09/2012 AC3 Picture 06/09/2012 03/09/2012
01/09/2012 HY7 Network 23/09/2012
04/09/2012 AC3 Network
04/09/2012 HY9 Picture 06/09/2012
05/10/2012 NJ9 Picture
05/10/2012 CC2 Unknown 30/10/2012
06/10/2012 AC3 Network 10/11/2012
11/10/2012 HY9 Network 09/11/2012
01/12/2012 CC2 Picture
18/12/2012 AC3 Unknown 05/01/2013

So, I want a formula that will tell me how many entries are in colum
provided that there is no entry in column D? And a second formula tha
will tell me if there is a blank in Columns D & E? I have this inf
along with the number of calls placed and the number of resolved call
on a second tab in the spreadsheet called Stats if that helps.

Thank you in advance for any assistance.

Amy :-

+-------------------------------------------------------------------
|Filename: CCTV FAults XL.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=814
+-------------------------------------------------------------------