Count cells matching across multiple ranges with multiple criteria ignore blanks & errors

HELP Please, Excel experts!!

I am completely stumped by this one.

I have an extensive workbook with a number of formulas calculating across the sheets - there are 4 'data input' sheets and a front 'summary' sheet which displays performance information.

On this front summary sheet I want to count the number of cells which match across multiple ranges with multiple criteria in one of the sheets.

Column A - Column B - Column C - Column D - Column E - Column F
Date Received - Shift Date - Date to be filled - Date Filled - Time to be filled - Time Filled
04/07/16 - 04/07/16 - 04/07/16 - 04/07/16 - 17:00 - 15:30
04/07/16 - 07/07/16 - 04/07/16 - 05/07/16 - 14:00 - 16:00
05/07/16 - 22/07/16 - 07/07/16 - 07/07/16 - 17:00 - 11:00
05/07/16 - 07/07/16 - 05/07/16 - [BLANK] - 14:30 - [BLANK]
[BLANK] - [BLANK] - #VALUE! - [BLANK] - #VALUE! - [BLANK]
[BLANK] - [BLANK] - #VALUE! - [BLANK] - #VALUE! - [BLANK]
[BLANK] - [BLANK] - #VALUE! - [BLANK] - #VALUE! - [BLANK]
[BLANK] - [BLANK] - #VALUE! - [BLANK] - #VALUE! - [BLANK]


Basically I need a formula to count the number of cells which match criteria across these types of ranges:

IF the 'Shift Date' = the 'Date Received', AND 'Date Filled' = the 'Date to be Filled', AND 'Time Filled' <= 'Time to be Filled' then count 1. As you can see the entire sheet has blanks and formulas calculating in the background in the ranges I am using. The formula I have tried is

=SUMPRODUCT(--NOT(ISERR('Bield Temp Tracker Jul-Sep 16'!B7:B500='Bield Temp Tracker Jul-Sep 16'!A7:A500)),SUMPRODUCT(--NOT(ISERR('Bield Temp Tracker Jul-Sep 16'!D7:D500='Bield Temp Tracker Jul-Sep 16'!C7:C500)),SUMPRODUCT(--NOT(ISERR('Bield Temp Tracker Jul-Sep 16'!F7:F500<='Bield Temp Tracker Jul-Sep 16'!E7:E500)))))

But get #VALUE! ?????

Am I using completely wrong formula type or just missing a few thing? - Any help would be greatly appreciated!!

Thank you in advance

Easier to do with a helper column.

In G2

=IFERROR(--AND(A2=B2,C2=D2,E2<=F2),0)

Fill that down, then sum the column.