I currently use the formula below that works fine however I need to add in
another condition that only returns a value if the department number is in
the range of say 1400 to 1499

=SUMPRODUCT(--('[2010-01 Group Trial Balance.xls]Group Trial Balance -
Current'!$B$4:$B$278=$A68)*('[2010-01 Group Trial Balance.xls]Group Trial
Balance - Current'!$D$4:$BY$278))

Thanks