Adding book reference/sheet references back in yourself, the syntax would be:

=SUMPRODUCT(--($B$4:$B$278=$A68),
--($C$4:$C$278=1400), --($C$4:$C$278<1500),
$D$4:$BY$278))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Curtis" wrote:

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