I have the following formula which worked on original data

=SUMPRODUCT(--('Raw data'!$AF$1:$AF$5291="0001-01-01"),--('Raw
data'!$L$1:$L$5291="railcomm1"))

In using this for new data, the result comes back with an #N/A, yet all data
is in the same place, but in a different order.

It won't let me trace the error, and can't see why its wrong. Please help

Column L Column AF
RAILCOMM0 12/07/2006
RAILCOMM1 0001-01-01
RAILCOMM1 0001-01-01
BTCAR1 0001-01-01
BTCOMM1 0001-01-01
BTCOMM0 12/07/2006
BTCOMM1 0001-01-01
BTCOMM1 0001-01-01
BTCOMM0 12/07/2006
BTCOMM1 0001-01-01
BTCOMM1 0001-01-01
GOVERNMENT DEPARTMENTSCAR1 0001-01-01
GOVERNMENT DEPARTMENTSCAR1 0001-01-01
GOVERNMENT DEPARTMENTSCAR1 0001-01-01