Hello from Steved

I Thankyou but I'm getting #VALUE! by using your formula

=SUMPRODUCT(($D$2:$D$3000="CITY DEPOT")*($B$2:$B$3000))
And also I did this.
{=SUMPRODUCT(($D$2:$D$3000="CITY DEPOT")*($B$2:$B$3000))}

The below is in Column B:B
{=IF(ISNA(VLOOKUP(A2,'Auckland
Kilometres'!$A$2:$G$1977,7,FALSE)),"0",VLOOKUP(A2, 'Auckland
Kilometres'!$A$2:$G$1977,7,FALSE))}


The below is in Column D:D
{=IF(ISNA(VLOOKUP(A2,'Auckland Kilometres'!$A$5:$E$4952,4,FALSE)),"Out Of
Service",VLOOKUP(A2,'Auckland Kilometres'!$A$5:$E$4952,4,FALSE))}




"Gary''s Student" wrote:

=SUMPRODUCT(($D$2:$D$3000="CITY DEPOT")*($B$2:$B$3000))
--
Gary''s Student - gsnu200853