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.