Hello from Steved

Ok Column D:D finds CITY DEPOT

once found add CITY DEPOT Kilometres in Column B:B

What is needed please to acheive adding Kilometres in Column B:B the below
is not working and I don't know what is wrong yes Columns B:B and D:D have
formulas.

=SUM(($D$2:$D$3000="CITY DEPOT")*$B$2:$B$3000)
{=SUM(($D$2:$D$3000="CITY DEPOT")*$B$2:$B$3000)}

Thankyou.

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

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

Hello from Steved

Thankyou I had another look and foun that a couple off the formulas were the
problem alls well



"Steved" wrote:

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